I exported one of my tables. Where is the export file stored and how can I identify it? My export was successful and I need to ftp the table I exported to our engineers...
If you didn't specify a dump file name and directory (exp logid/password file=
) then it should have gone to the default directory (i.e. wherever you were when you ran the export) or the default directory for the exp executable (usually ORACLE_HOME/bin). The name of the file will depend on your OS and should end in .dmp. Perhaps you should just do a search for any files ending in .dmp and see what turns up.
Dig Deeper on Oracle database export, import and migration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.