çææç表:
SELECT * FROM User_Objects WHERE object_type='TABLE'
表éçæ°æ®å¯¼åº:
EXP SCOTT/TIGER GRANTS=Y FULL=Y FILE=Your.dmp
----------------------------------------------------------------
Expçå½ä»¤å¸®å©ï¼
éè¿è¾å
¥ EXP å½ä»¤åç¨æ·å/å£ä»¤ï¼æ¨å¯ä»¥
åæ¥ç¨æ·å/å£ä»¤çå½ä»¤:
ä¾ç¨: EXP SCOTT/TIGER
æè
ï¼æ¨ä¹å¯ä»¥éè¿è¾å
¥è·æåç§åæ°ç EXP å½ä»¤æ¥æ§å¶â导åºâ
æç
§ä¸ååæ°ãè¦æå®åæ°ï¼æ¨å¯ä»¥ä½¿ç¨å
³é®å:
æ ¼å¼: EXP KEYWORD=value æ KEYWORD=(value1,value2,...,valueN)
ä¾ç¨: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
æ TABLES=(T1: P1,T1: P2)ï¼å¦æ T1 æ¯ååºè¡¨
USERID å¿
é¡»æ¯å½ä»¤è¡ä¸ç第ä¸ä¸ªåæ°ã
å
³é®å 说æ(é»è®¤) å
³é®å 说æ(é»è®¤)
--------------------------------------------------------------------------
USERID ç¨æ·å/å£ä»¤ FULL 导åºæ´ä¸ªæ件 (N)
BUFFER æ°æ®ç¼å²åºå¤§å° OWNER ææè
ç¨æ·åå表
FILE è¾åºæ件 (EXPDAT.DMP) TABLES 表å称å表
COMPRESS 导å
¥å°ä¸ä¸ªåº (Y) RECORDLENGTH IO è®°å½çé¿åº¦
GRANTS 导åºæé (Y) INCTYPE å¢é导åºç±»å
INDEXES 导åºç´¢å¼ (Y) RECORD è·è¸ªå¢éå¯¼åº (Y)
DIRECT ç´æ¥è·¯å¾ (N) TRIGGERS 导åºè§¦åå¨ (Y)
LOG å±å¹è¾åºçæ¥å¿æ件 STATISTICS åæ对象 (ESTIMATE)
ROWS 导åºæ°æ®è¡ (Y) PARFILE åæ°æ件å
CONSISTENT 交å表çä¸è´æ§ (N) CONSTRAINTS 导åºç约ææ¡ä»¶ (Y)
OBJECT_CONSISTENT åªå¨å¯¹è±¡å¯¼åºæé´è®¾ç½®ä¸ºè¯»çäºå¡å¤ç (N)
FEEDBACK æ¯ x è¡çæ¾ç¤ºè¿åº¦ (0)
FILESIZE æ¯ä¸ªè½¬å¨æ件çæ大大å°
FLASHBACK_SCN ç¨äºå°ä¼è¯å¿«ç
§è®¾ç½®å以åç¶æç SCN
FLASHBACK_TIME ç¨äºè·åææ¥è¿æå®æ¶é´ç SCN çæ¶é´
QUERY ç¨äºå¯¼åºè¡¨çåéç select åå¥
RESUMABLE éå°ä¸ç©ºæ ¼ç¸å
³çé误æ¶æèµ· (N)
RESUMABLE_NAME ç¨äºæ è¯å¯æ¢å¤è¯å¥çææ¬å符串
RESUMABLE_TIMEOUT RESUMABLE ççå¾
æ¶é´
TTS_FULL_CHECK 对 TTS æ§è¡å®æ´çæé¨åç¸å
³æ§æ£æ¥
TABLESPACES è¦å¯¼åºç表空é´å表
TRANSPORT_TABLESPACE 导åºå¯ä¼ è¾ç表空é´å
æ°æ® (N)
TEMPLATE è°ç¨ iAS 模å¼å¯¼åºç模æ¿å
温馨提示:答案为网友推荐,仅供参考