DMPæ¯Oracleç³»ç»ä¸ç转å¨æ件ãè§ä¸æï¼
DMPæ件ï¼EXP/IMPæä»¶ï¼ - ãOracle 9i & 10gç¼ç¨èºæ¯æ°æ®åºä½ç³»ç»æã
导åºå·¥å
·ï¼Exportï¼å导å
¥å·¥å
·ï¼Importï¼æ¯å¹´å¤´å·²ä¹
çOracleæ°æ®æ½ååå 载工å
·ï¼å¾å¤ä¸ªçæ¬ä¸é½æè¿äºå·¥å
·ã导åºå·¥å
·çä»»å¡æ¯å建ä¸ä¸ªå¹³å°ç¬ç«çDMPæ件ï¼è½¬å¨æ件ï¼ï¼å
¶ä¸å
å«ææå¿
è¦çå
æ°æ®ï¼CREATEåALTERè¯å¥å½¢å¼ï¼ï¼å¯è½è¿ææ°æ®æ¬èº«ï¼å¯ä»¥ç¨äºéæ°å建表ã模å¼çè³æ´ä¸ªæ°æ®åºã导å
¥å·¥å
·çæä¸ä½ç¨å°±æ¯è¯»åè¿äºDMPæ件ï¼æ§è¡å
¶DDLè¯å¥ï¼å¹¶å è½½å®æ¾å°çæææ°æ®ã
DMPæ件设计为ååå
¼å®¹ï¼è¿è¯´ææ°çæ¬å¯ä»¥è¯»åèçæ¬çDMPï¼å¹¶æåå°å¤çãæå¬è¯´æ人导åºè¿ä¸ä¸ªOracle 5çæ°æ®åºï¼å¹¶å°å
¶æåå°å¯¼å
¥å°Oracle 10gä¸ï¼åªæ¯ä¸ä¸ªæµè¯ï¼ï¼ãæ以导å
¥å·¥å
·å¯ä»¥è¯»åèçæ¬çDMPæ件ï¼å¹¶å¤çå
¶ä¸çæ°æ®ãä¸è¿ï¼å¤§å¤æ°æ
åµä¸åè¿æ¥ä¸æç«ï¼Oracle9i Release 1ç导å
¥å·¥å
·è¿ç¨ä¸è½ï¼ä¹ä¸ä¼ï¼æåå°è¯»åOracle9i Release 2 æ Oracle 10g Release 1å建çDMPãä¾å¦ï¼ææ¾ç»ä»Oracle 10g Release 1 åOracle9i Release 2导åºè¿ä¸ä¸ªç®åç表ãæè¯å¾å¨Oracle9i Release 1ä¸ä½¿ç¨è¿äºDMPæ件æ¶ï¼å¾å¿«åç°Oracle9i Release 1导å
¥å·¥å
·çè³ä¸æç®å¤çOracle 10g Release
1çDMPæ件ã
å¤çOracle9i Release 2æ件æ¶ï¼æ
åµä¹å¥½ä¸å°åªå¿å»ã
9i Release 1è¯å¾è¯»åæ件ï¼ä½å®æ æ³å¤çå
¶ä¸å
å«çDDLãOracle9i Release 2ä¸å¢å äºä¸ä¸ªæ°ç¹æ§ï¼ç§°ä¸ºè¡¨å缩ï¼table compressionï¼ãå æ¤ï¼è¿ä¸ªçæ¬ç导åºå·¥å
·å¼å§å¯¹æ¯æ¡CREATE TABLEè¯å¥å¢å ä¸ä¸ªNOCOMPRESSæCOMPRESSå
³é®åãOracle9i Release 2çDDLå¨Oracle9i Release 1ä¸æ æ³æ§è¡ã
ä¸è¿ï¼å¦æ对Oracle9i Release 2 æOracle 10g Release 1使ç¨Oracle9i Release 1 导åºå·¥å
·ï¼æ»ä¼å¾å°ä¸ä¸ªææçDMPæ件ï¼å¹¶å¯ä»¥æåå°å¯¼å
¥å°Oracle9i Release 1ä¸ãæ以ï¼å¯¹äºDMPæ件çè§åæ¯ï¼å建DMPæ件çExportçæ¬å¿
é¡»å°äºæçäºä½¿ç¨è¯¥DMPæ件çImportççæ¬ãè¦å°æ°æ®å¯¼å
¥Oracle9i Release 1ä¸ï¼å¿
须使ç¨Oracle9i Release 1ç导åºå·¥å
·ï¼æè
ä¹å¯ä»¥ä½¿ç¨ä¸ä¸ª8içExportè¿ç¨ï¼å建DMPæ件çExportçæ¬å¿
é¡»å°äºæçäºOracle9i Release 1ï¼ã
è¿äºDMPæ件æ¯å¹³å°ç¬ç«çï¼æ以å¯ä»¥å®å
¨å°ç¨ä»»ä½å¹³å°ç导åºå·¥å
·å建DMPæ件ï¼ç¶å转æ¢å°å¦ä¸ä¸ªå¹³å°ï¼å导å
¥è¿ä¸ªDMPæ件ï¼åªè¦Oracleçæ¬å
许ï¼ãä¸è¿ï¼å¯¹äºWindowsåæ件çFTPä¼ è¾æä¸ç¹è¦åï¼Windowsä¼é»è®¤å°æDMPæ件å½ææ¯ä¸ä¸ªâææ¬âæ件ï¼å¹¶ææ¢è¡ç¬¦ï¼UNIXä¸ä¸ºè¡æ«æ è®°ï¼è½¬æ¢ä¸ºå车/æ¢è¡å¯¹ï¼è¿å°±ä¼å®å
¨ç ´åDMPæ件ãå¨Windowsä¸éè¿FTPä¼ è¾DMPæ件æ¶ï¼è¦ç¡®ä¿ææ§è¡çæ¯äºè¿å¶ä¼ è¾ãå¦æ导å
¥ä¸æåï¼è¯·æ£æ¥æºæ件大å°åç®æ æ件大å°æ¯å¦ä¸æ ·ãè¿ç§é®é¢å¸¸å¸¸å¯¼è´ä»¤äººçè¦çå¼å¸¸ä¸æ¢ï¼èä¸å¾ä¸éä¼ æ件ï¼è¿ç§æ
åµåçè¿å¤å°æ¬¡æç®ç´é½è®°ä¸æ¸
äºã
DMPæ件æ¯äºè¿å¶æ件ï¼è¿è¯´æä½ ä¸è½ç¼è¾è¿äºæ件æ¥è¿è¡ä¿®æ¹ãå¯ä»¥ä»ä¸æ½å大éä¿¡æ¯ï¼CREATE DDLï¼ï¼ä½æ¯ä¸è½å¨ææ¬ç¼è¾å¨ï¼æè
å®é
ä¸ä»»ä½ç±»åçç¼è¾å¨ï¼ä¸ç¼è¾å®ä»¬ãå¨ç¬¬ä¸ççExpert One-on-One Oracleä¸ï¼ä½ æä¸çæ¯ç¬¬äºçï¼æ¬ä¹¦é
å¥å
çæä¾äºç¬¬ä¸çççµåææ¡£ï¼ï¼æè±äºå¤§éç¯å¹
讨论导å
¥å导åºå·¥å
·ï¼å¹¶ä»ç»äºå¦ä½ä½¿ç¨DMPæ件ãéçè¿äºå·¥å
·è¶æ¥è¶å¤±å® ï¼åè代ä¹çæ¯æ´ä¸ºçµæ´»çæ°æ®æ³µå·¥å
·ï¼æ以è¦æ³å
¨é¢å°äºè§£å¦ä½ç®¡ç导å
¥å导åºå·¥å
·ãå¦ä½ä»ä¸æ½åæ°æ®ä»¥åå¦ä½ä½¿ç¨è¿äºå·¥å
·ï¼è¯·åè第ä¸çççµåææ¡£ã
温馨提示:答案为网友推荐,仅供参考