oracleµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ
ÎҵĻúÆ÷°²×°µÄÊǿͻ§¶Ë£¬oracle9i£¬ÎÒÏÖÔÚÒѾÁ¬½ÓÉÏÒ»¸ö·þÎñÆ÷µÄÊý¾Ý¿â¡£
ÓÃpl_sqlµÇ½½øÈ¥ÁË¡£
µ«ÊÇÎÒÔÚdosÏÂÓÃexpµ¼³öʱ£¬ÏÔʾ
¼´½«µ¼³öÖ¸¶¨µÄÓû§...
.ÕýÔÚµ¼³öpre-schema¹ý³Ì¶ÔÏóºÍ²Ù×÷
È»ºó¾ÍһֱͣÔÚÕâÀûÓÐÏÂÎÄÁË¡£¡£ÇëÎʸ÷λ¸ßÊÖÕâÊÇʲôÔÒò°¡£¡
---------ÎÒʵÔںܲˣ¡£¡
ûÓÐÆäËûÌáʾÂð£¿
»òÕß³¢ÊÔÓÃpl/sql developer¹¤¾ßµ¼³öÊÔÊÔ
ûÓÐÁË£¡²»ÖªµÀÊDz»ÊÇÎÒµÄoracle°æ±¾ºÍ·þÎñÆ÷µÄ²»Ò»ÑùµÄÔÒò¡£
²»¹ý£¬ÄãËù˵µÄpl_sqlµ¼³ö£¬ÎÒûÓùý¡£ÏÈÊÔÊÔ¡£ºÇºÇ
ÎÒÊÔÁË¡£Ò²ÊÇ¿¨ÔÚÄDz»¶¯ÁË£¬ÎØÎØ¡£¡£¡£²»ÖªµÀΪʲô
Äã¶àµÈÒ»»á£¬Èç¹ûÓдí¾Í»á±©Â¶³öÀ´µÄ
log Àï×îºó¼¸ÐÐÊÇÔõô˵µÄ£¿
ÄÜ·ñÏêϸµã£¿ ÕâÑù¿´²»³öʲôµÄ°¡£¿
¶÷£¬ÎÒÔÚdosϵÈÁ˺þã¬Ã»ÓÐÈκα仯¡£Ìù¸öͼ¸ø´ó¼Ò¿´Ò»Ï£¡Ð»Ð»ÁË£¡
Ö¸¶¨log£¬È»ºó¿´logÀïµÄÃèÊö
лл´ó¼ÒµÄ°ï棬ÎÒÒѾ×Ô¼ºÕÒµ½ÔÒòÁË¡£ºÇºÇ¡£ÔÀ´ÊÇÎÒUSBת»»Æ÷µÄÊ£¬¶ÔÓÚÊý¾ÝÁ¿´óµÄËû¾Í»á¿¨ËÀ¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......