æ°æ®å¯¼åºï¼
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 å°æ°æ®åºä¸ç表inner_notifyãnotify_staff_relat导åº
exp aichannel/aichannel@TESTDB2 file= d:\data\newsmgnt.dmp tables=(inner_notify,notify_staff_relat)
4 å°æ°æ®åºä¸ç表table1ä¸çå段filed1以"00"æ头çæ°æ®å¯¼åº
exp system/manager@TEST file=d:\daochu.dmp tables=(table1) query=\" where filed1 like '00%'\" ä¸é¢æ¯å¸¸ç¨ç导åºï¼å¯¹äºå缩ï¼æ¢ç¨winzipædmpæ件å¯ä»¥å¾å¥½çå缩ã
ä¹å¯ä»¥å¨ä¸é¢å½ä»¤åé¢ å ä¸compress=y æ¥å®ç°ãæ°æ®ç导å
¥
温馨提示:答案为网友推荐,仅供参考