OraFAQ Forum: Server Utilities » On Import PLS-00302: component 'SET_NO

Home » RDBMS Server » Server Utilities » On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared (Oracle 10.2.0.1 DB on Windows 2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared [message #427666]

Fri, 23 October 2009 20:54

sdefilip
Messages: 5
Registered: March 2007

Junior Member

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 wanting to use SET_NO_OUTLINES and 9.2 not knowing what it is.

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

Report message to a moderator