PL/SQL Developeræ¯Oracleæ°æ®åºç¨äºå¯¼å ¥å¯¼åºæ°æ®åºç主è¦å·¥å ·ä¹ä¸ï¼æ¬æ主è¦ä»ç»å©ç¨PL/SQLå¯¼å ¥å¯¼åºOracleæ°æ®åºçè¿ç¨ã
1.Oracleæ°æ®åºå¯¼åºæ¥éª¤
1.1 ToolsâExport User Objects...é项ï¼å¯¼åº.sqlæ件ã
说æï¼æ¤æ¥éª¤å¯¼åºçæ¯å»ºè¡¨è¯å¥ï¼å æ¬åå¨ç»æï¼ã
1.2 ToolsâExport Tables...导åºè¡¨ç»æåæ°æ®
PL/SQLå·¥å ·å å«ä¸ç§æ¹å¼å¯¼åºOracle表ç»æåæ°æ®ï¼ä¸ç§æ¹å¼åå«ä¸ºï¼Oracle Export ãSQL InsertsãPL/SQL Developer,ä¸é¢åå«ç®åä»ç»ä¸åºå«ï¼
第ä¸ç§æ¹å¼å¯¼åº.dmpæ ¼å¼çæ件ï¼.dmpæ¯äºè¿å¶æ件ï¼å¯è·¨å¹³å°ï¼è¿è½å å«æéï¼æçä¸éï¼ç¨çæ为广æ³ã
<å�"/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHAgYWxpZ249"center">
第äºç§æ¹å¼å¯¼åº.sqlæ ¼å¼çæ件ï¼å¯ç¨ææ¬ç¼è¾å¨æ¥çï¼éç¨æ§æ¯è¾å¥½ï¼æçä¸å¦ç¬¬ä¸ç§ï¼éåå°æ°æ®é导å
¥å¯¼åºãå°¤å
¶æ³¨æçæ¯è¡¨ä¸ä¸è½æ大å段ï¼blob,clob,longï¼ï¼å¦ææï¼ä¼æ示ä¸è½å¯¼åº(æ示å¦ä¸ï¼ table contains one or more LONG columns cannot export in sql format,user Pl/sql developer format
instead)ã
第ä¸ç§æ¹å¼å¯¼åº.pdeæ ¼å¼çæ件ï¼.pde为PL/SQL Developerèªæçæä»¶æ ¼å¼ï¼åªè½ç¨PL/SQL Developerå·¥å ·å¯¼å ¥å¯¼åºï¼ä¸è½ç¨ææ¬ç¼è¾å¨æ¥çã
2. å¯¼å ¥æ¥éª¤(ToolsâImport Tables...)
å¯¼å ¥æ°æ®ä¹åæ好æ以åç表å æï¼å½ç¶å¯¼å ¥å¦å¤çæ°æ®åºæ°æ®é¤å¤ã
2.1 Oracle Import
å¯¼å ¥.dmpç±»åçoracleæ件ã
2.2 SQL Inserts
å¯¼å ¥.sqlç±»åçoracleæ件ã
2.3 PL/SQL Developer
å¯¼å ¥.pdeç±»åçoracleæ件ã
PL/SQL Developer å·¥å ·å¯¼å ¥å¯¼åºOracleæ°æ®åºå°±ç®åä»ç»å°è¿éäºï¼å¦ææé®é¢ï¼å¯ä»¥æç´¢PL/SQL Developer æä½æåï¼ä¹å¯ä»¥å¯¹ç¸å ³é®é¢è¿è¡æ索解å³ã