Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use dbms_datapump to import a table?

kaitokidscsSep 6 2013 — edited Sep 6 2013

--/

declare

h1 NUMBER;

begin

h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'TABLE', job_name => 'ddIMPORT1', version => 'COMPATIBLE');

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

dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);

dbms_datapump.add_file(handle => h1, filename => 'test.dmp', directory => 'DUMPFILE_DIR', filetype => 1);

dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');

dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 0);

dbms_datapump.start_job(handle => h1);

end;

I have error

12:49:49 [DECLARE - 0 row(s), 0.000 secs] [Error Code: 31627, SQL State: 99999] ORA-31627: API call succeeded but more information is available

ORA-06512: at "SYS.DBMS_DATAPUMP", line 5531

ORA-06512: at line 10

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2013

Added on Sep 6 2013

#database-key-features, #export-import-sql-loader-external-tables

11 comments

4,082 views