Oracle10.2 dblink impd copies data from different users in the same database

Oracle10.2 dblink impd: copying data from different users in the same database and copying data from different users in the same database

1. authorize the user to import tables; SQL> grant exp_full_database to system; SQL> commit; 2. create dblink; SQL> create public database link db_link1 connect to system identified by sys using 'orcl '; SQL> commit; 3. import impd; [$ ORACLE_HOME/bin] $ impdp system/sys logfile = temp. log schemas = from_user remap_schema = from_user: to_user network_link = db_link1 4. delete dblink. SQL> drop public database link; SQL> commit;

 

Note: 1. Database Operation User: system/sys2. service name ORCLE: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames. ora

ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl )))