CODEWITHSUNDEEP
sqldatabaseoracle10g
Mahesh
Mahesh

Reputation: 13

how to export dump file for oracle10g I tried in the following way SQL> expdp dump dumfile=filename.dmp

I tried to dump but I am getting a error in SQL command prompt.

How to export dump file for oracle10g I tried in the follwing way: SQL> expdp dump dumfile=filename.dmp

Upvotes: 0

Views: 751

Answers (1)

Alex Poole
Alex Poole

Reputation: 191275

expdp is an operating system command, not an SQL command. You need to run it from an operating system command prompt.

There is more information in the documentation, including descriptions of the command parameters (and as noted it is dumpfile rather than dumfile), and they provide examples.

If you haven't used it before, be aware that the dump file is created on the server in a location identified by the directory parameter, which is set to the name of a database directory object - not to a directory path you'd recognise. This is quite different from the old exp command.

The minimum would be something like:

expdp <user>/<password> DIRECTORY=<directory> DUMPFILE=<filename>.dmp

... with your own sensible values for the <> placeholders. But investigate all the options to make sure you export what you need. It rather depends why you're doing the export, and what you'll do with the dump file later, I suppose...

Upvotes: 2

Related Questions