Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-06550 error when importing a 10.2 dmp file into a 9.2 database

An Oracle user asks Database Backup and Recovery expert Brian Peasland why they are getting the ORA-06550 error error when importing a 10.2 dmp file into a 9.2 database.

I have an Oracle 10.2.0.2 dmp file from another site. I need to import the data into a 9.2.0.6 database on HP-UX11.11. I cannot modify the export file nor do I have a 10.2 database to import into, but I do have the 10.2 software. Is there any way to import the 10.2 dmp file into a 9.2 database?

I attempted to import using the 9.2 software and it didn't recognize the dmp file. I then tried using 10.2 software to import into the 9.2 database and received the error:

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

Since the dump file was most likely created with the 10g exp utility, the only way I could import the dump file's contents would be to create a simple 10g database, then import the contents. Use the 9i exp utility to create a new dump file and then import into the 9i database. At this point, I would delete the 10g database I temporarily created.

Getting the ORA-06550 error when exporting? Read this expert response.

For more solutions to common Oracle errors, check out our Solving common Oracle errors guide.

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close