exp userid=system/manager owner=scott file='/data/exp/test03.dmp' 

exp test/test file=exp.dmp log=exp.log
 
 
imp system/manager file=/data/exp/test03.dmp fromuser=scott touser=scott
 
imp test/test file=exp.dmp log=imp.log
 
 
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