SQL> create directory datapump as '/app/oracle/export';
Directory created.
SQL> create user datapump identified by datapump;
User created.
SQL> grant create session, exp_full_database, imp_full_database to datapump;
Grant succeeded.
conn datapump:
SQL> create database link JDED_TEST connect to testdta identified by **** using 'JDED';
Database link created.
SQL> alter user datapump default tablespace reddtat;
User altered.
SQL> alter user datapump quota unlimited on reddtat;
expdp.par:
userid=datapump/****@JDERED
DIRECTORY=datapump
NETWORK_LINK=JDED_TEST
DUMPFILE=jded_test1.dmp
LOGFILE=jded_test1.log
tables=TESTDTA.DATAPUMP_1
impdp.par:
userid=datapump/****@JDERED
DIRECTORY=datapump
DUMPFILE=jded_test1.dmp
LOGFILE=jded_test_imp.log
REMAP_SCHEMA=TESTDTA:REDDTA
REMAP_TABLESPACE=TESTDTAT:REDDTAT
REMAP_TABLESPACE=TESDTAI:REDDTAT
Directory created.
SQL> create user datapump identified by datapump;
User created.
SQL> grant create session, exp_full_database, imp_full_database to datapump;
Grant succeeded.
conn datapump:
SQL> create database link JDED_TEST connect to testdta identified by **** using 'JDED';
Database link created.
SQL> alter user datapump default tablespace reddtat;
User altered.
SQL> alter user datapump quota unlimited on reddtat;
expdp.par:
userid=datapump/****@JDERED
DIRECTORY=datapump
NETWORK_LINK=JDED_TEST
DUMPFILE=jded_test1.dmp
LOGFILE=jded_test1.log
tables=TESTDTA.DATAPUMP_1
impdp.par:
userid=datapump/****@JDERED
DIRECTORY=datapump
DUMPFILE=jded_test1.dmp
LOGFILE=jded_test_imp.log
REMAP_SCHEMA=TESTDTA:REDDTA
REMAP_TABLESPACE=TESTDTAT:REDDTAT
REMAP_TABLESPACE=TESDTAI:REDDTAT
No comments:
Post a Comment