½éÉÜ£¬Ö®Ç°¾³£ÓÐÈËѯÎÊOracleÊý¾Ý¿âµ¼³öµ¼ÈëµÄ·½·¨£¬È¥ÍøÉϲéѯ£¬µ«ÊDzéѯµÄ½á¹ûÈ´²»ÊǺܾ¡ÈçÈËÒ⣬ËùÒÔÔÚ´Ë×ö¸ö»ù±¾µÄ×ܽᣬ°üÀ¨µ¼³ö:(µ¼³öÓû§£¬µ¼³ö±í£¬µ¼³ö±í½á¹¹²»´øÊý¾Ý£¬QUERY²ÎÊý),µ¼Èë(µ¼ÈëÊý¾ÝÎļþ£¬µ¼Èë±í½á¹¹£¬µ¼ÈëÊý¾ÝºöÂÔ±í½á¹¹£¬½öµ¼ÈëÊý¾Ý)¡£Ê¹ÓõIJÎÊý°´ÕÕ×ÔÈÏΪʹÓÃƵÂÊÓɸߵ½µÍ½éÉÜ£¬ÄÚÈÝÏà±È½ÏEXP°ïÖúÎĵµ²»È«£¬µ«ÊÇ×ã¹»Ó¦¶Ô»ù±¾µÄ¹¤×÷ÈÎÎñ£¬Ïë×ÐϸÑо¿µÄ½¨Òé²é¿´°ïÖúÎĵµ¡£ºóÐøÄÚÈÝÓбä¸ü»á¼°Ê±Ôö¼Ó¡£
µ¼³öÃüÁîEXP
EXP USER/PASSWORD@SID FILE=EXPDAT.DMP [ PARAMETER²ÎÊý]
USER£ºÓû§Ãû
PASSWORD:ÃÜÂë
SID:Êý¾Ý¿âʵÀýÃû
FILE:Êä³öÎļþ(EXPDAT.DMP)Êä³öµÄÎļþÃû×Ö
DIRECT:µ¼³öµÄÖ±½Ó·¾¶,µ¼³öÎļþµÄËùÔÚ·¾¶£¬Êä³öÎļþµÄ·¾¶Ò²¿ÉÒÔÖ±½ÓдÔÚfileÖÐ
EXP USER/PASSWORD@SID FILE=DIRECT/EXPDAT.DMP [ TABLES=|OWNER=|...]
OWNER:Êý¾Ý¿âÓû§Ãû
TABLES:Êý¾Ý¿â±íÁбí,Ö§³Ö¶à±íµ¼³ö
EXP USER/PASSWORD@SID FILE=EXPDAT.DMP TABLES=TABLE1 TABLE2 ...
ROWS:µ¼³öÊý¾ÝÐРĬÈÏÊÇYµ¼³ö±íºÍÊý¾Ý£¬µ±ROWS=NÖ»µ¼³ö±í½á¹¹Ã»ÓÐÊý¾Ý
QUERY:ÐèҪעÒâµÄÊÇÖ»ÔÚ±íģʽ(±íģʽ¾ÍÊǵ¼³ö±íµÄ²Ù×÷)ÖÐÓÐЧ
EXP USER/PASSWORD@SID FILE=EXPDAT.DMP TABLES=TBNAME QUERY=\"WHERE ID='1'\"
FULL:µ¼³öÕû¸öÎļþ(N )
GRANTS:µ¼³öȨÏÞ(Y)
INDEXES:µ¼³öË÷Òý(Y)
INCTYPE:ÔöÁ¿µ¼³öÀàÐÍ
TRIGGERS:µ¼³ö´¥·¢Æ÷(Y)
CONSTRAINTS:µ¼³öµÄÔ¼ÊøÌõ¼þ(Y)
BUFFER :Êý¾Ý»º³åÇøµÄ´óС
LOG:ÆÁÄ»Êä³öµÄÈÕÖ¾Îļþ
µ¼ÈëÃüÁî(IMP)
IMP USER/PASSWORD@SID FILE=EXPDAT.DMP [ PARAMETER ]
FILE:ÊäÈëÎļþ(EXPDAT.DMP)ÊäÈëµÄÎļþÃû×Ö
FULL:µ¼ÈëÕû¸öÎļþ ĬÈÏ(N)Ò»°ã¸ø (Y)
IGNORE:ºöÂÔ´´½¨´íÎó(N)
IMP USER/PASSWORD@SID FILE=EXPDAT.DMP IGNORE=Y FULL=Y
ROWS:µ¼ÈëÊý¾ÝÐÐ(Y)
DATA_ONLY:½öµ¼ÈëÊý¾Ý(Y)
IMP USER/PASSWORD@SID FILE=EXPDAT.DMP DATA_ONLY=Y FULL=Y
GRANTS :µ¼ÈëȨÏÞ(Y)
INDEXES :µ¼ÈëË÷Òý(Y)
INCTYPE :ÔöÁ¿µ¼ÈëÀàÐÍ