ORA-30014 Error during import OUTLN tables

Today I had a problem while moving outlines from a Development environment to Test environment. This operation is basically a export (in the database which are the outlines) and import (in the target database). You can find out more about the detail of the process at this link.

Performing the import I got the following errors;

undo_manual_error

After analyzing the problem, and although there are several errors I have seen that the main error is;

ORA-30014: operation only supported in Automatic Undo Management mode

From documentation

Error: ORA-30014 (ORA-30014)
Text: operation only supported in Automatic Undo Management mode
—————————————————————————
Cause: the operation is only supported in automatic undo mode.
Action: restart instance in Automatic Undo Management mode before
retrying operation.

This database support Siebel and is currently involved in a process of upgrading. Siebel documentation recommending use of Rollback Segment instead of UNDO.  Activating UNDO (setting UNDO_MANAGEMENT to auto and unsetting rollback_segments) solves the problem.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s