I have a small problem, I am not able to import the dpdump file that I created and send to the RDS Oracle Instance. Actually the error I receice leads me to believe the file is not even there.
When I ran the following commands as per the online documentation, everything went well, no errors.
Since I don't have shell access I have no way knowing if my file actaully made it. Do you guys know of any way to find out if this file is there. Or maybe I made a mistake somewhere and overlooked something?
Please, any help is appreciated as I am totally stuck now.
DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.open( operation => 'EXPORT', job_mode => 'SCHEMA', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'schema1.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.add_file( handle => hdnl, filename => 'schema1.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''schema1'')');
DBMS_DATAPUMP.start_job(hdnl);
END;
BEGIN
DBMS_FILE_TRANSFER.PUT_FILE(
source_directory_object => 'DATA_PUMP_DIR',
source_file_name => 'schema1.DMP',
destination_directory_object => 'DATA_PUMP_DIR',
destination_file_name => 'schema1.dmp',
destination_database => 'amazon2'
);
END;
/
C:\>impdp MainUser@amazon DUMPFILE=NGSSC.DMP DIRECTORY=DATA_PUMP_DIR full=y
Import: Release 11.2.0.3.0 - Production on Sat Mar 7 21:05:05 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/rdsdbdata/datapump/SCHEMA1.DMP" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thank you very much.
Steve
I verified that the destination directory is setup properly
DATA_PUMP_DIR = /rdsdbdata/datapump
Hi Steve,
RépondreSupprimerI am also having the same issue.
Please let me know if you got a solution.
Regards,
Abhijit