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

HP-UXÖÐÓ¦ÓóÌÐòÎÞ·¨Æô¶¯oracle 10g

ÔÚHP-UX°²×°HPÐÔÄÜÕ¹ÏÖ²úÆ·OVPI£¬°²×°¹ý³ÌÐèҪֹͣOracleÊý¾Ý¿âʵÀý£¬²¢Æô¶¯¡£Êý¾Ý¿â˳ÀûÍ£Ö¹ºó£¬È»ºó¾ÍÒ»Ö±´¦ÓÚÆô¶¯×´Ì¬£¬²¢ÇÒ²»±¨´í£¡ÎÊÌâ»á³öÔÚʲôµØ·½ÄØ£¿
¶¥Ò»Ï£¡¸÷λÇë°ï棡

¶¥Ò»Ï£¡¸÷λÇë°ï棡

ÄãÊÇÔõÑùÅжÏÊÇÒ»Ö±´¦ÓÚÆô¶¯×´Ì¬µÄ?

Í£Ö¹ÄãÓõÄÊÇʲôÑùµÄ·½Ê½ºÍÃüÁîÍ£Ö¹µÄ?

°ÑÄãµÄÍ£Ö¹Êý¾Ý¿âµÄÃüÁîÌù³öÀ´£¬´ó¼Ò¾ÍÖªµÀÄãΪʲô Êý¾Ý¿âÍ£Ö¹Ö®ºó£¬Êý¾Ý¿â»¹ÊÇÆô¶¯×ŵÄÀ²£¡

°Ñ alert.logÀïÃæÏà¹ØÐÅÏ¢ÄóöÀ´É¹ÏÂ.
λÖÃÔÚ$ORACLE_BASE/ADMIN/(your sid)/bdump ÏÂ



End_rbody_59955597//-->
¸Ã»Ø¸´ÓÚ2009-09-21 17:07:52±»°æÖ÷ɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP









qige5231
(Æß¸ç)

µÈ¡¡¼¶£º



#7Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-01-29 14:16:07


ÎÊÌâ½â¾öÁË£¬¼àÌýûÓÐÅäºÃ£¬ÕýÈ·ÅäÖÃÁËlistener.ora£¬ÖØÐ°²×°¾ÍºÃÁË£¡Ð»Ð»´ó¼Ò²ÎÓ룡


Ïà¹ØÎÊ´ð£º

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

ÊÇ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µ¼Èë»Ø¹ö - Oracle / ¿ª·¢

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

Äã² ......

oracleÈçºÎʵÏÖ´ø²ÎÊýµÄ·ÖÒ³²éѯ

ÇëÎÊÔÚoracleÖÐÈçºÎʵÏÖЧ¹û¾ÍÏñÔÚSQL ServerÖÐ"select top " + pageSize + " * from tb_user where id not in (select top " + curPage*pageSize + " id from tb_user) and units_id=1&qu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ