Ask the Expert

Export terminates before it ends properly

When I export in database, the export terminated before it ends properly. There is no message or warning in the expert log file. There are two instances in the database and both have the same problem, though the actual line where it terminates is different.

Last 4 lines in instance 1:

    Requires Free Membership to View

exporting triggers
. exporting snapshots
. exporting snapshot logs
. exporting job queues

Last 4 lines in instance 2:
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes

When I import the dump file, we get the following message in the import log:

IMP-00009: abnormal end of export file Import terminated successfully with warnings.
Obviously, the abnormal termination of the export process resulted in the IMP-00009 error. You'll need to perform a valid export. The big question is why the export terminates without warning. The first place I'd look is in my USER_DUMP_DEST directory for a trace file generated at the time the export terminated. It will contain valuable clues as to why the export didn't complete successfully.

This was first published in March 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: