oracleÊý¾Ýµ¼Èëµ¼³ö

µ¥±íÊý¾ÝǨÒÆ£ºÖ§³Öclob,blob
      exp estarcom/estarcom@ORACLE  tables=AA direct=y file=C:/AAA1.dmp
¡¡¡¡ imp estarcom/estarcom@ORACLE  tables=AA  file=C:/AAA1.dmp fromuser=estarcom touser=estarcom
È«¿âÊý¾ÝǨÒÆ
exp userid=zhongxin/zhongxin@ORACLE owner=zhongxin file=d:/zhongxin_200811111946.dmp log=d:/zhongxin_200811111946.log
imp zhongxin/zhongxin@oracle file=d:/mianyang_20081119.dmp fromuser=mianyang touser=zhongxin
EXP/IMPÓ÷¨
exp/impÊʺÏÓÚͬÀàÐÍÊý¾Ý¿âÖ®¼äÊý¾Ýת»»
¹²ÓÐËÄÖÖ²»Í¬Ä£Ê½:±í,Óû§,±í¿Õ¼ä,Êý¾Ý¿â
ÏÖ·Ö±ð¾ÙÀý˵Ã÷
1.±í¼¶±ð
$ exp hr/hr tables=jobs direct=y file=/data/table_jobs.dmp
$ imp hr/hr tables=jobs direct=y file=/data/table_jobs.dmp
2.Óû§¼¶±ð
$ exp "'sys/sys as sysdba'" owner=hr direct=y file=/data/owner_hr.dmp
$ imp "'sys/sys as sysdba'" fromuser=hr touser=hr file=/data/owner_hr.dmp
 
3.±í¿Õ¼ä¼¶±ð
$ exp "'sys/sys as sysdba'" transport_tablespace=y direct=y tablespaces=examples file=/data/ts_examples.dmp
 
4.Êý¾Ý¿â¼¶±ð
$ exp "'sys/sys as sysdba'" full=y  file=/data/db.dmp
 
˵Ã÷£ºÈçҪʹÓÃas sysdba»òas sysoper½øÐвÙ×÷£¬Ôò±ØÐëʹ
     ÓÃÈçÏÂÓ÷¨£º
     "'sys/sys as sysdba'"
     "'system/system as sysoper'"