Hi,
I am trying to do a datapump import using network_link, but it doesn't work. My db is 11.2.0.3.7 on Solaris.
I've tried to create the db link as private and public. No difference.
Here is what I did:
sql>create database link somedblinkname connect to dan identified by "daniel4321" using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=myserver2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=mydatabase)))';
Database link created.
sql>
select instance_name from V$instance@somedblinkname;
INSTANCE_NAME
----------------
mydatabase
sql>
select username from dba_users where username='SCOTT';
USERNAME
------------------------------
SCOTT
impdp dan1 schemas=scott remap_schema=scott:tmpdaniel directory=DPUMPDIR NETWORK_LINK=sommedblinkname
Import: Release 11.2.0.3.0 - Production on Thu Dec 19 12:39:27 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORA-39001: invalid argument value
ORA-39170: Schema expression 'SCOTT' does not correspond to any schemas.
I am trying to import schema SCOTT from database1 into schema TMPDANIEL in database2. User SCOTT exist in the database1, but it doesn't exist in database2.
User dan1 and dan that is used in the DB link, have import and export full database roles and also dba role (imp/exp roles should be in dba role, but i granted explicitly also).
The db link works properly and I can query everything in database2 from database1.
The import should be started from database1 or from database2? Does it matter from where i'm starting the import?
Why do I get the above error?
Thanks,
Daniel