Home » RDBMS Server » Server Utilities » On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared (Oracle DB on Windows 2000)
On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared [message #427666] Fri, 23 October 2009 20:54 Go to next message
Messages: 5
Registered: March 2007
Junior Member
Windows 2000 Server
Oracle upgraded from

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 database from a 9.2.0 database export.dmp file that was exported with the export utility. I am using the import utility of the destination database ( ($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.
Re: On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared [message #427685 is a reply to message #427666] Sat, 24 October 2009 01:24 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: How to Load the data from single file to Multiple tables using SQL* Loader
Next Topic: Imporve the import performance
Goto Forum:

Current Time: Wed Oct 26 05:21:47 CDT 2016

Total time taken to generate the page: 0.11423 seconds