messages that Export issues in certain situations - Oracle 8i

Warning, Error, and Completion Messages
This section discusses the messages that Export issues in certain situations.

Log File
You can capture all Export messages in a log file, either by using the LOG parameter or, for those systems that permit it, by redirecting Export’s output to a file. The Export utility writes a log of detailed information about successful unloads and any errors that may occur.

Warning Messages
Export does not terminate after nonfatal errors. For example, if an error occurs while exporting a table, Export displays (or logs) an error message, skips to the next table, and continues processing. These nonfatal errors are known as warnings. Export issues a warning whenever it encounters an invalid object.

For example, if a nonexistent table is specified as part of a table-mode export, the Export utility exports all other tables.
Then, it issues a warning and terminates successfully, as shown in the following listing:

> exp scott/tiger tables=xxx,emp

Export: Release 8.1.6.0.0 - Production on Wed Oct 6 15:25:15 1999

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.6.0.0 - Production
Export done in WE8DEC character set and WE8DEC NCHAR character set

About to export specified tables via Conventional Path ...
EXP-00011: SCOTT.XXX does not exist
. . exporting table EMP 14 rows exported
Export terminated successfully with warnings.

Fatal Error Messages
Some errors are fatal and terminate the Export session. These errors typically occur because of an internal problem or because a resource, such as memory, is not available or has been exhausted. For example, if the CATEXP.SQL script is not executed, Export issues the following fatal error message:

EXP-00024: Export views not installed, please notify your DBA

Completion Messages
When Export completes without errors, Export displays the message "Export terminated successfully without warnings." If one or more nonfatal errors occurs but Export is able to continue to completion, Export displays the message "Export terminated successfully with warnings." If a fatal error occurs, Export terminates immediately with the message "Export terminated unsuccessfully."


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 8i Topics