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)
On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared [message #427666] Fri, 23 October 2009 20:54 Go to next message
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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/t/50716/0/
http://forums.oracle.com/forums/thread.jspa?messageID=2721519
http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1263536,00.html

Regards
Michel
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: Thu Mar 28 11:11:23 CDT 2024