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

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 


SQL> select name from v$database;

NAME
---------
ORCL


ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£

´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£

ÓÃÈýÂ¥µÄ·½·¨²éһϾÍÖªµÀÊÇʲôÁË

ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£

ÒýÓÃ
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£


ÕûÈËÓÐÒâ˼Â𣿡¡ÖªµÀ´ð°¸Ö±½Ó·¢ÉÏÀ´¹²Í¬Ñ§Ï°¡£¡¡Ñ§Ï°ÒªÇ«Ð飬¡¡Ã¿È˶¼ÓÐ×Ô¼ºµÄÓŵ㡣¡¡±ðÈËÈÈÐĵİïÄ㣬»¹³ö¿ÚÂîÈË£¬ÓÖ¼ûÒ»¸ö¸öÐÔµÄ90ºó£¬ ÕæÎÞÓïѽ.. ÒÔºó»¹ÏëÔÚÕâÀï»ì£¬×îºÃÇ«Ðéµã..

liuxinyu19901016


ÏȰÑÕâÌù¶¥ÆðÀ´£¬Èôó¼Ò¶¼ÈÏʶÈÏʶÄã.. liuxinyu19901016

¹þ¹þ 
90ºó¡­¡­

ʲô½ÐÖªµÀ´ð°¸£¬ÕâÊǺóÀ´Ñ§Ï°²éÕÒ¸ãÃ÷°×µÄ¡£Ê²Ã´½ÐÎÒÑÛ¾¦ÓÐÎÊÌ⣬²»ÖªµÀ¾ÍÊDz»ÖªµÀ»¹ÓýƱçÂð£¿ÎÞÓï¡£¡£¡£¡£¡£

ºÇºÇ
ºÍг ÂÛ̳ÐèÒªºÍг

1
¼´±ãÊÇÄãºóÀ´×Ô¼ºÍ¨¹ýѧϰ¸ãÃ÷°×ÁË Ò²ÒªÀ´ºÍ´ó¼Ò·ÖÏíÒ»ÏÂѽ ÔõôÄÜÖ»Îʲ»·ÖÏíÄØ ¶Ô²»¶Ô ÂÛ̳¾ÍÊÇÒ»¸ö´ó¼Ò»¥°ï»¥Öú¹²Ïí֪ʶµÄµØ·½

2
¼´±ãij¸öÈË˵´íÁË»° ÄãÒ²²»ÄÜ˵´ó¼Ò¶¼ÊÇÖí°É ºÇºÇ

ÒýÓÃ
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£




Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

¹ØÓÚoracle 10gµÄsqlplus

ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390

×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ

×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ