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

Receiving error at export command

I have a problem trying to export a database and I cannot figure out what it might be. When writing this line of command (exp user/pass@orcl file=c:scott.dmb full=y), I receive an error message.

I have a problem trying to export a database and I cannot figure out what it might be. When writing this line of command:
exp user/pass@orcl file=c:scott.dmb full=y
I receive the following message:
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully.
It appears that you are using incompatible versions of your Oracle export utility compared to your database version. The rule of thumb to follow is to use the same export version matching your Oracle database. If you use Oracle 10g's exp utility to dump the contents of an Oracle 9i database, you can hit this exact error. Use the 9i exp utility instead.

Dig Deeper on Oracle database design and architecture

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