å½ç¶ï¼ç¨å·¥å
·å¯¼åºæ¯ææ¹ä¾¿çï¼è¦æ¯ç´æ¥ç¨é»çªå£å¯¼åºä¹æ¯å¾æ¹ä¾¿çã
è¿ä¸ªå¯¼åºçè¯ï¼ä½ å¯ä»¥å
·ä½çä¸ç½ææï¼æ¬å°çå°±ç´æ¥å¯¼åºå°±è¡ï¼
æ°æ®å¯¼åºï¼
1 å°æ°æ®åºTESTå®å
¨å¯¼åº,ç¨æ·åsystem å¯ç manager 导åºå°D:\daochu.dmpä¸
exp system/manager@TEST file=d:\daochu.dmp full=y
2 å°æ°æ®åºä¸systemç¨æ·ä¸sysç¨æ·ç表导åº
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
3 å°æ°æ®åºä¸ç表table1 ãtable2导åº
exp system/manager@TEST file=d:\daochu.dmp tables=(table1,table2)
4 å°æ°æ®åºä¸ç表table1ä¸çå段filed1以"00"æ头çæ°æ®å¯¼åº
exp system/manager@TEST file=d:\daochu.dmp tables=(table1) query=\" where filed1 like '00%'\"
å¦ææ¯è¿ç¨çè¯ä¹æ¯å¯ä»¥çï¼
C:\Documents and Settings\Administrator>exp tmrpt/
[email protected]:1521/bocReport file=c:\yuCheng\event_log_realtime.d
mp tables=(event_log_realtime);