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µÄÇé¿öÏ£¬²ÅÓвÎÊý¡£ËüÊÇһϵÁеÄÊý¾Ý¿âÕʺţ
Ïà¹ØÎĵµ£º
¶Ô±í½øÐзÖÎö£¬Í¨³£Çé¿öÏ¿ÉÒÔ¶Ô±í£¬Ë÷Òý£¬ÁнøÐе¥¶À·ÖÎö£¬»òÕß½øÐÐ×éºÏ·ÖÎö£¬µ«ÕâÈýÕßÄÄЩÊÇÏà¶ÔÖØÒªµÄ£¬ÄÄЩ·ÖÎöÏԵò»ÄÇôÖØÒª£¿Í¨¹ý±¾ÆªÎÄÕµÄʵÑéÏàÐÅ´ó¼ÒÒ²»á¶ÔÖ±·½Í¼ÓиüÒ»²½µÄÁ˽â.
1.Ê×ÏÈ´´½¨²âÊÔ±í,²¢²åÈë100000ÌõÊý¾Ý
SQL> create table test(id number,nick varchar2(30));
Table created.
SQL> b ......
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 ......
Ò»¡¢ÏµÍ³Ó²¼þÐèÇó
1¡¢ÖÁÉÙ1024MBÎïÀíÄÚ´æ(3114848)
# grep MemTotal /proc/meminfo
2¡¢¿ÉÓý»»»ÇøÒªÇóÈçÏÂ±í£º
# grep SwapTotal /proc/meminfo
¿ÉÓÃÄÚ´æ
½»»»Çø´óС
Between 1024 MB and 2048 MB
1.5 times the size of ......