Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»¸ö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 Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ