oracleÓйصÄ4¸öÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÈçÌâ: 1.OracleµÄȱʡÊý¾ÝÎļþ¸öÊý?²»Í¬µÄ°æ±¾ÊÇÒ»ÑùÂ𣿶¼ÊÇ30Â𣿠2.expdpºÍimpdpµÄ²Ù×÷ȨÏÞ£¬ÊÇexp_full_database/imp_full_databaseÂ𣿠3.ÁÙʱ±í¿Õ¼äÓÐʲôÓã¿ 4.н¨Êý¾Ý¿â,Èç¹û×¢²á±íûÓÐ...oracle/HOMExxxÕâ¸öÏÐèÒªÊÖ¶¯¼ÓÂ𣿲»¼ÓÓÐʲôӰÏ죿
»ù´¡ÖªÊ¶ ºÃºÃÕÆÎÕ ´ø¸öµÊ×ÓµÈÈ˻ظ´ 1, ²»Í¬°æ±¾µÄȱʡÎļþ¸öÊý¿Ï¶¨²»Í¬£¬ÒòΪËæ×Å°æ±¾µÄÌá¸ß£¬oracle»áÐÂÔöһЩ¸¨ÖúµÄtablespace£¬Ò²¾Í»áÔö¼ÓһЩÊý¾ÝÎļþ£¬ÁíÍ⣬30Õâ¸öÊý×ÖÂ¥Ö÷ÔõôµÃµ½µÄ£¿ºÃÏñûÄÇô¶à¡£ 2£¬²»ÊìϤ£» 3£¬ÅÅÐòʱ»áÓõ½ÁÙʱ±í¿Õ¼ä 4£¬³ý·ÇÄãÊÖ¹¤É¾³ý£¬Ò»°ã×¢²á±í¶¼ÓжÔӦѡÏÒýÓà 1, ²»Í¬°æ±¾µÄȱʡÎļþ¸öÊý¿Ï¶¨²»Í¬£¬ÒòΪËæ×Å°æ±¾µÄÌá¸ß£¬oracle»áÐÂÔöһЩ¸¨ÖúµÄtablespace£¬Ò²¾Í»áÔö¼ÓһЩÊý¾ÝÎļþ£¬ÁíÍ⣬30Õâ¸öÊý×ÖÂ¥Ö÷ÔõôµÃµ½µÄ£¿ºÃÏñûÄÇô¶à¡£ 4£¬³ý·ÇÄãÊÖ¹¤É¾³ý£¬Ò»°ã×¢²á±í¶¼ÓжÔӦѡÏ 1.¼ÇµÃ²»ÊǺÜÇå³þÁË£¡²»ÖªÊÇ10g»¹ÊÇ11g£¬Ä¬ÈϵÄÊý¾ÝÎļþ¸öÊýÊÇ30£¬µ±È»Ëæ×ÅÒµÎñµÄÔö³¤£¬¿ÉÒÔÔÚ¿ØÖÆÎļþÖУ¬»¹¿ÉÒÔÐÞ¸Ä×î´óÊý¾ÝÎļþµÄ¸öÊý¡£ 4.²»ÊÇɾ³ý£¬ÊÇÎÒ´´½¨µÄÊý¾Ý¿âÍêºó£¬×¢²á±íÖÐûÓÐÕâ¸ö¶ÔÓ¦Ï ×Ô¼º¶¥Ï£¡ 1.OracleµÄȱʡÊý¾ÝÎļþ¸öÊý?²»Í¬µÄ°æ±¾ÊÇÒ»ÑùÂ𣿶¼ÊÇ30Â𣿠2.expdpºÍimpdpµÄ²Ù×÷ȨÏÞ£¬ÊÇexp_full_database/imp_full_databaseÂ𣿠3.ÁÙʱ±í¿Õ¼äÓÐʲôÓã¿ 4.н¨Êý¾Ý¿â,Èç¹û×¢²á±íûÓÐ...oracle/HOMExxxÕâ¸öÏÐèÒªÊÖ¶¯¼ÓÂ𣿲»¼ÓÓÐʲôӰÏ죿 tangren ÒѾ»Ø´ðÁËÄãµÄÎÊÌâÁËѽ Ö§³Ö tangren ·¹ý ·¢Ò»Ï ¶¥Ò»Ï oracle QQȺºÅ£º54775466 »¶ÓÕâ·½Ã
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......