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ÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
±¾À´ÒªÐ´¸ö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 ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
ÇëÎÊÔÚ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 ......