é£å°±è¦é对æ
åµå
·ä½åæï¼ä¸è¬å¯åèå¦ä¸æ¹æ³ï¼
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)
6. 估计导åºæ件ç大å°
å
¨é¨è¡¨æ»åèæ°ï¼
SELECT sum(bytes) FROM dba_segments WHERE segment_type = 'TABLE';
seaparkç¨æ·æå±è¡¨çæ»åèæ°ï¼
SELECT sum(bytes) FROM dba_segments WHERE owner = 'SEAPARK' AND segment_type = 'TABLE';
seaparkç¨æ·ä¸çaquatic_animal表çåèæ°ï¼
SELECT sum(bytes) FROM dba_segments WHERE owner = 'SEAPARK' AND segment_type = 'TABLE' AND segment_name = 'AQUATIC_ANIMAL';
7. 导åºè¡¨æ°æ®çåé(oracle8i以ä¸)
NTç³»ç»ï¼
exp system/manager query='Where salad_type='FRUIT'' tables=amy.salad_type file=fruit log=fruit
UNIXç³»ç»ï¼
exp system/manager query=\"Where salad_type=\'FRUIT\'\" tables=amy.salad_type file=fruit log=fruit
8. ç¨å¤ä¸ªæ件åå²ä¸ä¸ªå¯¼åºæ件
exp system/manager file=(paycheck_1,paycheck_2,paycheck_3,paycheck_4) log=paycheck, filesize=1G tables=hr.paycheck
9. 使ç¨åæ°æ件
exp system/manager parfile=bible_tables.par
bible_tables.paråæ°æ件ï¼
#Export the sample tables used for the Oracle8i Database Administrator's Bible.
ããããfile=bible_tables
ããããlog=bible_tables
ããããtables=(
ããããamy.artist
ããããamy.books
ããããseapark.checkup
ããããseapark.items
ãããã)
ãã
10. å¢é导åº
âå®å
¨âå¢é导åº(complete)ï¼å³å¤ä»½æ´ä¸ªæ°æ®åº
exp system/manager inctype=complete file=990702.dmp
âå¢éåâå¢é导åº(incremental)ï¼å³å¤ä»½ä¸ä¸æ¬¡å¤ä»½åæ¹åçæ°æ®
exp system/manager inctype=incremental file=990702.dmp
â累计åâå¢é导åº(cumulative)ï¼å³å¤ä»½ä¸ä¸æ¬¡âå®å
¨â导åºä¹åæ¹åçæ°æ®
exp system/manager inctype=cumulative file=990702.dmp
温馨提示:答案为网友推荐,仅供参考