Database Utilities (MOSC)

MOSC Banner

While Invoking 10.2.0.1 Import : PLS-00302: component 'SET_NO_OUTLINES' must be declared

edited Oct 27, 2009 6:04AM in Database Utilities (MOSC) 8 commentsAnswered
 Windows 2000 Server Oracle 10.2.0.1 upgraded from 9.2.0.1

IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

Trying to import into a 10.2.0.1 database from a 9.2.0 database export.dmp file that was exported with the 9.2.0.1 export utility. I am using the import utility of the destination database (10.2.0.1) $ORACLE_HOME/ora102/bin and the db_block values are the same for both source and destination databases.

I think this is caused by Oracle 10.2 want to use SET_NO_OUTLINES and 9.2 doesn't know what it is.

Would appreciate any advise in fixing or working around this situation.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center