We have a dump file that we want to import into the Amazon RAD server.
This is what I did:
Create a public db link and make sure it works:
create public database link rdsdblink
connect to dbuser identified by dbpsw
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST='xxx')(PORT=1521)))(CONNECT_DATA=(SID=dbsid)))';
SQL> select * from dual @ rdsdblink;
D
-
X
Create a directory for the dump file:
CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS 'G:\DB';
Import dump file:
impdp dbuser/dbpsw@rdsdblink tablespaces=EMP directory=DATA_PUMP_DIR dumpfile=EMP_dump.DMP logfile=EMP_dump.log network_link=rdsdblink
I also added the rdsdblink connection string to the tnsnames.ora file and restarted the oracle service ("shutdown immediately", then "startup").
The following error has occurred:
Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
ORA-39001: Invalid argument value
ORA-39200: Invalid link name "rdsdblink".
ORA-02019: connection description for remote database not found
:
Oracle Database 11g Express Edition Release 11.2.0.2.0 -
:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production