oracle imp\exp Óï·¨¼ò½é
ORACLE EXP/IMP ²ÎÊýÏê½â
2008-01-09 18:16
ORACLE EXP/IMP ²ÎÊýÏê½â
===========================================================
×÷Õß: magic21(http://magic21.itpub.net)
·¢±íÓÚ: 2007.09.27 10:46
·ÖÀà: ÈÕ»ýÔÂÀÛ
³ö´¦: http://magic21.itpub.net/post/5324/400048
---------------------------------------------------------------
EXPµ¼³öÑ¡Ïî
¹Ø¼ü×Ö
ÄÚÈÝ
USERID
ÔËÐе¼³öÃüÁîµÄÕʺŵÄÓû§Ãû/¿ÚÁî
BUFFEER
ÓÃÀ´È¡Êý¾ÝÐеĻº³åÇøµÄ´óС
FILE
µ¼³öת´¢ÎļþµÄÃû×Ö
EXPµ¼³öÑ¡Ïî
¹Ø¼ü×Ö
ÄÚÈÝ
USERID
ÔËÐе¼³öÃüÁîµÄÕʺŵÄÓû§Ãû/¿ÚÁî
BUFFEER
ÓÃÀ´È¡Êý¾ÝÐеĻº³åÇøµÄ´óС
FILE
µ¼³öת´¢ÎļþµÄÃû×Ö
COMPRESS
µ¼³öÊÇ·ñÓ¦¸ÃѹËõÓÐËéƬµÄ¶Î³ÉÒ»¸ö·¶Î§£¬Õ⽫»áÓ°ÏìSTORAGE×Ó¾ä
GRANTS
µ¼³öʱ·ñÒªµ¼³öÊý¾Ý¿â¶ÔÏóÉϵÄÊÚȨ
INDEXES
ÊÇ·ñÒªµ¼³ö±íÉϵÄË÷Òý
ROWS
ÊÇ·ñÓ¦µ¼³öÐС£ÈçËüΪ‘N’£¬ÄÇôÔÚµ¼³öÎļþÖнöÉú³ÉÊý¾Ý¿â¶ÔÏóµÄDDL
CONSSTRAINTS
ÊÇ·ñµ¼³ö±í¾ÉµÄÔ¼¶¨Ìõ¼þ
FULL
ÈçÉèΪ‘Y’£¬ÄÇô½«Ö´ÐÐÒ»¸öÕû¸öÊý¾Ý¿âµ¼³ö²Ù×÷
OWNER
Òªµ¼³öµÄһϵÁÐÊý¾Ý¿âÕʺţ¬È»ºóÖ´ÐÐÕâЩÕʺŵÄUSERµ¼³ö²Ù×÷
TABLES
Òªµ¼³öµÄһϵÁÐ±í£»Ö´ÐÐÕâЩ±íµÄTABLEµ¼³ö²Ù×÷
RECORDLENGTH
ת´¢µ¼³öÎļþÈÕÖ¾µÄ³¤¶È(ÒÔ×Ö½ÚΪµ¥Î»)£¬Í¨³£¶¼Ê¹ÓÃȱʡ£¬³ý·ÇÒªÔÚÁ½¸ö²»Í¬²Ù×÷ϵͳÖд«µÝµ¼³öÎļþ
INCTYPE
ÕýÔÚÖ´Ðеĵ¼³ö²Ù×÷µÄÀàÐÍ£¨ÓÐЧֵÓÐCOMPLETE(ȱʡֵ)£¬CUMULATIVEºÍIVCREMENTAL£©
RECORD
ÔÚÔöÁ¿µ¼³öÀàÐÍÖеÄÒ»¸ö±ê¼Ç£¬±êÃ÷ÊÇ·ñ½«ÈÕÖ¾´æ´¢µ½Êý¾Ý×ÖµäÖÐÈÕÖ¾µ¼³öµÄ±íÖÐ
PARFILE
Òª´«µÝ¸øµ¼³öµÄ²ÎÊýÎļþµÄÃû×Ö¡£Õâ¸öÎļþ½«°üº¬ËùÓвÎÊýµÄÈë¿ÚÏî
ANALYZE
±êÃ÷ÊÇ·ñ½«ÒƶÔÏóµÄͳ¼ÆÐÅϢдÈëµ¼³öת´¢ÎļþÖÐ
CONSISTENT
±êÃ÷ÊÇ·ñ±£ÁôËùÓе¼³ö¶ÔÏóµÄ¶ÁÈ¡Ò»Ö¸´ÖÆ
LOG
µ¼³öÈÕÖ¾½«ÒªÐ´ÈëµÄÎļþµÄÃû×Ö
MLS
±êÃ÷ÊÇ·ñÒªµ¼³öMLS ±êºÅ
MLS_LABEL
¹æ¶¨ÁËMLS±êºÅµÄ¸ñʽ
IMPµ¼ÈëÑ¡Ïî
¹Ø¼ü×Ö
ÄÚÈÝ
USERID
ÔËÐе¼ÈëÃüÁîµÄÕʺŵÄÓû§Ãû/¿ÚÁî
BUFFEER
ÓÃÀ´È¡Êý¾ÝÐеĻº³åÇøµÄ´óС
FILE
µ¼Èëת´¢ÎļþµÄÃû×Ö
SHOW
¹æ¶¨ÎļþÄÚÈÝÊÇ·ñ±»ÏÔʾ£¬¶ø²»ÊDZ»Ö´ÐÐ
EGNORE
±êÃ÷ÔÚÖ´ÐБCREATE’ÃüÁîʱ£¬ÊÇ·ñºöÂÔÓöµ½µÄ´íÎó¡£Èç¹ûÕýÔÚµ¼ÈëµÄ¶ÔÏóÒѾ´æÔÚʱ£¬Ó¦Ê¹ÓÃÕâ¸ö²ÎÊý
FULL
ÈçÉèΪ‘Y’£¬ÄÇô½«Ö´ÐÐÒ»¸öÕû¸öÊý¾Ý¿âµ¼Èë²Ù×÷
fromUSER
ÔÚFULL=NµÄÇé¿öÏ£¬²ÅÓвÎÊý¡£ËüÊÇһϵÁеÄÊý¾Ý¿âÕʺţ
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
1.Ê×ÏȽ«Òªµ¼ÈëµÄÊý¾ÝÉú³ÉexcelÎļþ¸ñʽ£¬×îÇ°Ãæ¿ÕÒ»¸ñ¡£
2.ÓÃPL/SQLÁ¬½ÓÒªµ¼ÈëµÄÊý¾Ý¿â£¬ÊäÈëÓï¾ä select * from ±íÃû for update
3.µã»÷СËø£¨±à¼Êý¾Ý£©£¬Ñ¡ÖÐÒ»Ðн«excel¸´ÖÆÊý¾ÝÕ³Ìùµ½±íÖÐ
ÒÔinformixÊý¾Ýµ¼³öΪÀý£¬Ê×ÏÈʹÓÃSecureCRT¹¤¾ß½øÈëÖնˡ£ÊäÈëÃüÁîdbaccessºóÖ´ÐУ¬Ñ¡ÖÐÊý¾Ý¿âNEWÒ»ÏÂSQLÓï¾äÊäÈëÃüÁunl ......
Õâ¶Îʱ¼ä£¬½ÓµÄ¶àÊÇRACµÄά»¤ºÍ»Ö¸´ÎÊÌâ¡£ËùÒÔÿÌ춼ÊÇÔÚºÍRAC´ò½»µÀ¡£
RACÕæµÄºÜºÃÍæ¡£
´ó¼ÒÓжÔRAC¸ÐÐËȤµÄÓÐÎÊÌâµÄ£¬»òÕßÊÇÓöµ½RACά»¤ÉÏÃæµÄ³öÏÖÎÊÌâµÄ£¬¿ÉÒÔ·¢ÓʼþÖÁinthirties@gmail.comÒ»Æð½»Á÷Ñо¿¡£
ÕæµÄºÜÏ£ÍûÍæOracle ......
oracle9iºÍ10gµÄÏÂÔصØÖ·
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92 ......
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃ湤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle - OraDb10g_home1”&mdash ......