Warning, Error, and Completion Messages
This section discusses the messages that Export issues in certain situations.
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.
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 22.214.171.124.0 - Production on Wed Oct 6 15:25:15 1999
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 126.96.36.199.0 - Production
With the Partitioning and Java options
PL/SQL Release 188.8.131.52.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
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."
Oracle 8i Related Interview Questions
|Oracle 10g Interview Questions||Oracle 9i Interview Questions|
|Oracle 8i Interview Questions||Informatica Interview Questions|
|PL/SQL Interview Questions||Oracle 11g Interview Questions|
|SQL Interview Questions||Oracle apps Interview Questions|
|Sybase Interview Questions||Oracle Apps ERP Interview Questions|
|Oracle 7.3 Interview Questions||Oracle Access Manager Interview Questions|
|Oracle Application Framework Interview Questions||Oracle Apps DBA Interview Questions|
Oracle 8i Related Practice Tests
|Oracle 10g Practice Tests||Oracle 9i Practice Tests|
|Oracle 8i Practice Tests||Informatica Practice Tests|
|PL/SQL Practice Tests||Oracle 11g Practice Tests|
|SQL Practice Tests||Oracle apps Practice Tests|
|Sybase Practice Tests||Oracle Apps ERP Practice Tests|
|Oracle 7.3 Practice Tests|
Oracle 8i Tutorial
Sql*loader Case Studies
Sql*loader Control File Reference
Sql*loader Command-line Reference
Sql*loader: Log File Reference
Sql*loader: Conventional And Direct Path Loads
Dbverify: Offline Database Verification Utility
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.