1

I just imported data into an Amazon RDS DB instance using this guide

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

But in the source DB the number of tables is 309 whereas that for the target DB is only 4

select count('1') from dba_tables where owner='NUNITO';

Is there a way to see the log files ?

I used

DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.OPEN( operation => 'EXPORT', job_mode => 'SCHEMA', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'sample.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'exp.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''SCHEMA_1'')');
DBMS_DATAPUMP.START_JOB(hdnl);
END;
/
Improve this question
2
  • 1
    Of course, you can transfer the log files using the method described in Step 5.
    – Balazs Papp
    Commented Nov 12, 2017 at 21:40
  • That guide lists multiple ways to import data (e.g. DMS, data pump). Which did you use?
    – CalZ
    Commented Nov 14, 2017 at 15:08

1 Answer 1

Reset to default
1
+50

You can see a list of the files in the DATA_PUMP_DIR directory by running

 select * from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) order by filename;

Additionally, you can read the contents of the file by using

select * from table(RDSADMIN.RDS_FILE_UTIL.READ_TEXT_FILE('DATA_PUMP_DIR','filename.log'));

(Credit for the last script goes to: https://www.experts-exchange.com/questions/28961936/open-a-file-on-a-remote-server-amazon-rds-oracle.html)

I hope it helps

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.