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
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