This content has been marked as final. Show 3 replies
Then I create a DB link within TARGETUSER schema in targetDB.
In source DB, I am going to create a user called JOHN and grant IMP_FULL_DATABASE to JOHN. In Target DB, I am going to create a user called TARGETUSER and grant IMP_FULL_DATABASE and CREATE DATABASE LINK privilege.
CREATE DATABASE LINK mylink CONNECT TO john IDENTIFIED BY password USING '10.81.24.213:1521/SOURCEDB';
Now, in in target machine, I invoke impdp like
TargetDB SourceDB (which has the schemas schema1,schema2,schema3) TARGETUSER -------------------------> JOHN via DB Link
Are the above steps correct ?
impdp TARGETUSER/pass schemas=schema1,schema2,schema3 network_link=mylink LOGFILE=3schemasNetworkImport_imp.log