Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

How to use DBMS_DATAPUMP to write to a dba directory to your local client?

edited Jan 8, 2016 12:25PM in Database Install/Upgrade/Opatch (MOSC) 5 commentsAnswered ✓

I would like to create a export dump file using DBMS_DATAPUMP to write to a directory on your local client. For example using the below script where LOCAL_DB_DIR is local to the client and not to the DB server.

------------------------------------------------------------------------------------------------------------------------

declare

h1 NUMBER;

begin

h1 := dbms_datapump.open(operation => 'EXPORT', job_mode => 'SCHEMA', job_name => 'SCHEMA_IMP_JOB');

dbms_datapump.add_file(handle => h1, filename => 'schema_x.dmp', directory => 'LOCAL_DB_DIR');

dbms_datapump.add_file(handle => h1, filename => 'schema_x.log', directory => 'LOCAL_DB_DIR', filetype => 3);

dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center