copy an exported dump file to a target DB instance - LOG 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 =&gt; 'EXPORT', job_mode =&gt; 'SCHEMA', job_name=&gt;null);
DBMS_DATAPUMP.ADD_FILE( handle =&gt; hdnl, filename =&gt; 'sample.dmp', directory =&gt; 'DATA_PUMP_DIR', filetype =&gt; dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.ADD_FILE( handle =&gt; hdnl, filename =&gt; 'exp.log', directory =&gt; 'DATA_PUMP_DIR', filetype =&gt; dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''SCHEMA_1'')');
DBMS_DATAPUMP.START_JOB(hdnl);
END;
/
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