How to run Oracle datapump export


Performing a datapump export

See what directories are already setup:

SELECT * FROM dba_directories

If you need to create a new location:

CREATE DIRECTORY dmpdir AS ‘/opt/oracle’;
GRANT read, write ON DIRECTORY dmpdir TO scott;

Export the data

expdp schemas=xxxxx direcotry=dmpdir filename=filename .


Leave a Reply

Your email address will not be published. Required fields are marked *