oracle OCP¿¼ÊÔºÍÔ³§Åàѵ·ÑÓà - Oracle / ·Ç¼¼ÊõÇø
´ó¼ÒÖªµÀoracle OCP¿¼ÊԵķÑÓÃô£¿
ÎÒÔÚÑÇÍþÅàѵµÃµ½µÄÐÅÏ¢ÊÇ£º
ͨ¹ýOCP¿¼ÊÔÐèÒª-1Z0-043£¬¿¼ÊÔ·ÑÓà RMB 1125£¬´ËÍâ»ñµÃOCPÈÏÖ¤Ê黹ÐèÒªÓÐÒ»ÃÅoracleÔ³§Åàѵͨ¹ýµÄÖ¤Ã÷Êé
²»ÖªµÀ´ó¼ÒÊÇ·ñÖªµÀÕâ¸öoracle Ô³§ÅàѵµÄ·ÑÓôó¸ÅÊǶàÉÙ£¿×îºÃÒѾ»ñµÃOCPÖ¤ÊéµÄÈ˸ø¸ö´ð°¸¡£Ð»Ð»
ÎÒÒ²Ï뿼 ²»Çå³þ Äãgoogle à²à²
µÈ´ýÓйýORACLEÈÏÖ¤µÄǰ±²ÃǵÄÖ¸µã
ÓÑÇéUp£¡~ Ò²ºÜ¹Ø×¢..
End_rbody_65953204//-->
¸Ã»Ø¸´ÓÚ2010-06-08 08:57:28±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
yuhongpingimu
(ˮľ)
µÈ¡¡¼¶£º
#5Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-06-03 18:24:16
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......