æ£å¸¸å°±æ¯expçæ¹æ³æå¿«ï¼å¯¼å ¥æ¯impçæ¹å¼ä¹æ¯æå¿«ç
å ·ä½expè¯æ³
1. è·å帮å©
ããããexp help=y
ãã
ãã2. 导åºä¸ä¸ªå®æ´æ°æ®åº
ããããexp system/manager file=bible_db log=dible_db full=y
ãã
ãã3. 导åºæ°æ®åºå®ä¹èä¸å¯¼åºæ°æ®
ããããexp system/manager file=bible_db log=dible_db full=y rows=n
ãã
ãã4. 导åºä¸ä¸ªæä¸ç»æå®ç¨æ·æå±çå
¨é¨è¡¨ãç´¢å¼åå
¶ä»å¯¹è±¡
ããããexp system/manager file=seapark log=seapark owner=seapark
ããããexp system/manager file=seapark log=seapark owner=(seapark,amy,amyc,harold)
ãã注æï¼å¨å¯¼åºç¨æ·æ¶ï¼å°½ç®¡å·²ç»å¾å°äºè¿ä¸ªç¨æ·çææ对象ï¼ä½æ¯è¿æ¯ä¸è½å¾å°è¿äºå¯¹è±¡å¼ç¨çä»»ä½åä¹è¯ã解å³æ¹æ³æ¯ç¨ä»¥ä¸çSQL*Pluså½ä»¤å建ä¸ä¸ªèæ¬æ件ï¼è¿è¡è¿ä¸ªèæ¬æ件å¯ä»¥è·å¾ä¸ä¸ªé建seaparkæå±å¯¹è±¡çå
¨é¨å
Œ
±åä¹è¯çå¯æ§è¡èæ¬ï¼ç¶åå¨ç®æ æ°æ®åºä¸è¿è¡è¯¥èæ¬å°±å¯é建åä¹è¯äºã
ãã
ããããSET LINESIZE 132
ããããSET PAGESIZE 0
ããããSET TRIMSPOOL ON
ããããSPOOL c:\seapark.syn
ããããSELECT 'Create public synonym '||synonym_name
ãããã||' for '||table_owner||'.'||table_name||';'
ããããFROM dba_synonyms
ããããWHERE table_owner = 'SEAPARK' AND owner = 'PUBLIC';
ããããSPOOL OFF
ãã
ãã5. 导åºä¸ä¸ªæå¤ä¸ªæå®è¡¨
ããããexp seapark/seapark file=tank log=tank tables=tank
ããããexp system/manager file=tank log=tank tables=seapark.tank
ããããexp system/manager file=tank log=tank tables=(seapark.tank,amy.artist)
ãã