Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ