Ò»¸öoracle±í»Ö¸´ÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÊÌ⣺Èç¹ûÒ»¸ö±í±» drop£¬ÔÚÓÐÍêÉÆµÄ¹éµµºÍ±¸·ÝµÄÇé¿öÏ£¬ÈçºÎ»Ö¸´£¿ 1£¬×ö¸ö»ùÓÚ±íµÄ»Ö¸´¾ÍÐÐÁË¡£ 2£¬ÖªµÀdropʱ¼äµÄ»°£¬×ö¸ö»ùÓÚʱ¼äµÄ»Ö¸´¡£ 3£¬ÖªµÀscnºÅµÄ»°£¬»ùÓÚscn»Ö¸´¡£ ÎÊÏ´ó¼Ò£¬Õâ3ÖÖ»ùÓÚÈ«¿â»Ö¸´µÄrecoverÓï¾äÎÒ»áд£¬µ«ÊÇ»ùÓÚdrop±íµÄ¾Í²»ÖªµÀÔõôд»Ö¸´Óï¾äÁË£¬´ó¼ÒÖªµÀµÄ¸æËßÏ£¬Ð»Ð»£¡
»ùÓÚ±íµÄ£¿ÊDz»ÊÇflashback? sql>flashback table xxxxx_table_name to before drop;ÒýÓà »ùÓÚ±íµÄ£¿ÊDz»ÊÇflashback? sql>flashback table xxxxx_table_name to before drop; Õâ¸öÉÁ»ØÓï¾ä»Ö¸´Óï¾ä£¬ÎÒÖªµÀ£¬µ«ÊÇÎÒ²»ÖªµÀËûÌâÄ¿Òâ˼ÊÇÎ浀 ÉÁ»Ø»Ö¸´Â𣿠»ùÓÚ±í£¬Ö»ÄÜÊÇÉÁ»ØÁË£» Èç¹ûÓÐÂß¼exp±¸·Ý£¬µ±È»¿ÉÒÔʹÓÃimpµ¼ÈëÖ¸¶¨µÄ±í¡£ »ùÓÚ±í£¬Í¨³£¶¼ÊÇÊÇÉÁ»Ø£» Èç¹ûÓÐÂß¼exp±¸·Ý£¬¿ÉÒÔʹÓÃimpµ¼ÈëÖ¸¶¨µÄ±í¡£ Èç3Â¥Ëù˵µÄ Èç¹ûÓб¸·ÝµÄ»°£¬¾Í¿ÉÒÔµ¼Èë½øÀ´°¡ ºÙºÙ£¡
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......