Ò»¸ö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Â¥Ëù˵µÄ Èç¹ûÓб¸·ÝµÄ»°£¬¾Í¿ÉÒÔµ¼Èë½øÀ´°¡ ºÙºÙ£¡
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¼ÙÉè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£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......