Q

Which IMP messages are warnings and which are errors?

How can you differentiate in Oracle 9i between import messages (IMP-nnnnn) that are warnings and the ones the are error messages? For example, in case of IMP-00015 the import will terminate successfully with warnings, but in case of IMP-00022 or IMP-00058 the import will terminate unsuccessfully.

How can you differentiate in Oracle 9i between import messages (IMP-nnnnn) that are warnings and the ones the are error messages? For example, in case of IMP-00015 the import will terminate successfully with warnings, but in case of IMP-00022 or IMP-00058 the import will terminate unsuccessfully. (IMP-00000 is also reported in this case.)
When I check an import status in a batch of shell scripts, I grep for the affirmative message "import completed without errors," using the import logfile, like this:
u01apporaclelogs> grep -i 'import completed successfully" 
my_import_logfile.txt
This was first published in November 2005

Dig deeper on Oracle error messages

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close