Ask the Expert

Where is the export data stored?

I am using the following command to export the table:
EXP user/password@instance TABLE=(table)
The export is done successfully. But I have no idea where this export data is stored. Where is this file stored so that I can use it to import on a different machine?

    Requires Free Membership to View

The dump file will be in the directory your session was in when you invoked the exp utility. The default file name of the dump file is expdat.dmp. You can specify a file name for the dump file with the FILE= parameter. Optionally, you can include a directory path in the file name. The following examples illustrate this for Unix and Windows respectively:

exp userid=user/pass@tnsalias table=(my_table)
file=/home/oracle/my_table.dmp
exp userid=user/pass@tnsalias table=(my_table)
file=c:tempmy_table.dmp

This was first published in September 2005

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: