|
 |
|
How to check for import completed successfully message
Oracle Tips by Burleson Consulting
Updated 30 May 2010 |
Question:
How can I check import messages (IMP-nnnnn) and
distinguish between 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.)
How can I automatically check to see if my data
pump import job completed successfully?
Answer:
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:
u01/app/oracle/logs> grep -i 'import completed
successfully" my_import_logfile.txt
For more complete details, see
the book
Oracle Shell Scripting.
|
|
 |
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
|
