[ oracle ] oracle export and import 오라클 백업 및 복원하기

 

 

imp system/manager file=/data/exp/test03.dmp fromuser=scott touser=scott

 

 

 

10g 이후론

 

 

(sql에서) create or replace directory dp as   'c:\경로' ;

 

 

export

 

$ expdp system/oracle directory=dp dumpfile=test01.dmp full=y

$ expdp system/oracle directory=dp dumpfile=test01.dmp schemas=scott exclude=table:\"=\'EMP\'\"

$ expdp system/oracle directory=dp dumpfile=test02.dmp schemas=scott \
  exclude=table:\"IN \(\'EMP\', \'DEPT\'\)\"

$ expdp system/oracle directory=dp dumpfile=test03.dmp schemas=scott \
  exclude=index:\"\=\'idx_emp_ename\'\"

$ expdp system/oracle directory=dp dumpfile=test04.dmp schemas=scott \
  query=emp:\"\'where sal \> 1000\'\"

$ expdp system/oracle directory=dp dumpfile=test_p_%U.dmp schemas=scott \
  job_name=dp_t1 parallel=4

$ expdp system/oracle attach=dp_t1

 

 

 

import

 

$ impdp system/oracle dumpfile=test01.dmp table_exists_action=truncate schemas=scott

 

$ impdp system/oracle directory=dp dumpfile=test01.dmp table_exists_action=truncate schemas=scott

$ impdp system/oracle directory=dp dumpfile=test02.dmp schemas=scott \
  remap_schema=scott:hr

$ impdp system/oracle directory=dp dumpfile=test02.dmp schemas=scott \
  remap_tablespace='users':'example' table_exists_action=truncate