oracle的expdp和impdp命令研究，oracleexpdpimpdp

oracle的expdp和impdp命令研究，oracleexpdpimpdp
--建立遠端資料串連
create database link DB_MZDB11  connect to YTMZTWO identified by YTMZTWO909  using 'MZDB11';  
--建立本地目錄
create directory db_mz as 'c:';
--授權使用者讀寫
grant read,write on directory db_mz to YTMZTWO,YTMZ;
--授權使用者可以建立dblink
grant create database link to YTMZTWO,YTMZ;


grant resource to YTMZTWO;




--匯出命令 
expdp YTMZTWO/YTMZ2.2 schemas=YTMZTWO dumpfile=YTMZTWO.DMP directory=db_mz network_link=DB_MZDB11 logfile=log.log exclude=TABLE:\" IN \(\'PUB_ATTACHMENT\',\'PUB_SIGNSEAL\'\)\"


--在設定檔中新增內容
ORCL_rxxc =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 61.139.100.204)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORACLE)
    )
  )
--直接匯入資料命令
impdp YTMZTWO/YTMZ2.2 directory=db_mz NETWORK_LINK=DB_MZDB11 schemas=YTMZTWO  logfile=log.log exclude=TABLE:\" IN \(\'PUB_ATTACHMENT\',\'PUB_SIGNSEAL\'\)\"
 job_name=my_job