oracleѧϰÃÔ»ó
ÎÒÊÇÒ»¸öJava³ÌÐòÔ±£¬×öÁËÁ½ÈýÄêÁË£¬ÏÖÔÚÕýºÃÓÃoracle±È½Ï¶à£¬Ïë
¶àѧѧoracle¡£µ«ÊÇ£¬ÎÒÓÖ²»ÊÇDBAÖ®ÀàµÄÖ±½ÓºÍoracleÌìÌìÅÝÔÚÒ»ÆðµÄ£¬
µ£ÐÄѧÆðÀ´µÄ»°£¬ÓкܶàÌõ¼þ²»ÄÜÔÊÐí¡£
ÎÒÖ»ÄÜÔÚ×Ô¼º»úÆ÷ÉÏ×°ÉÏoracle·þÎñÆ÷À´Ñ§Ï°£¬µ«±¾»úȷʵ²»ÄÜÈݵÄÏÂ
Õâ¸öÅÓ´óµÄ¶«Î÷¡£Èç¹ûÕæµÄÖ»ÊÇÔÚÎҵĵçÄÔÉÏÀ´Ñ§Ï°µÄ»°£¬²»ÖªµÀÄÜѧµ½
ʲôµØ²½£¬ÈçºÎ²ÅÄÜÀ©Õ¹×Ô¼ºµÄ֪ʶ¡£
Ò²²»ÖªµÀÕâôѧ£¬ÄÜ·ñ¶Ô×Ô¼ºµÄoracleÕæÊÇÓкõİïÖú¡£
¸Ð¾õÎÒÏÖÔÚѧoracle£¬¸ü¶àµÄÊÇÔÚ¹Ø×¢sqlÓï¾ä£¨È·Êµ²»Ôõô»áÓã©£¬µ½
µ×ѧϰoracleÊÇÓÐÄÄЩ´óµÄ·½ÃæÊÇÒª¹Ø×¢µÄ£¬È»ºóÈç¹ûҪϸ»¯µÄ»°£¬¸ÃÔõô
¸ãÄØ¡£
ÏÈ¿´¿´»ù±¾µÄÎĵµ£¬´òºÃ»ù´¡¡£
³ýÁËSQL/PLSQL£¬ORACLE»¹ÓкܶණÎ÷¡£¿´ÄãÏëÏòÄÄ·½Ãæ·¢Õ¹ÁË¡£
Èç¹ûÏë×öDBA£¬°²×°/ÅäÖᢱ¸·Ý/»Ö¸´£¬ÐÔÄܵ÷Õû£¬¶¼ÊDZØÐëµÄ£¡
Ò»¸öORACLE DBMS+Ò»¸öѧϰÊý¾Ý¿â£¬Ö»ÒªÊý¾ÝÁ¿²»´ó£¬²»»á³¬¹ý10G£¬ÏÖÔÚµÄÓ²ÅÌ£¬×ã¹»ÁË¡£
²»ÖªµÀÓÐÄÄЩºÃÊéÖµµÃÍÆ¼öÄØ¡£
Áí£ºÒ»Ì¨µçÄÔÖ÷»ú¿ÉÒÔÓжà¸öÈ«¾ÖÊý¾Ý¿âÂð£¿
ORACLEµÄÎĵµ£¬¾ÍÊÇ×îºÃµÄÊé¡£µ±È»£¬ÊÇÓ¢Îĵġ£
Áí£ºÒ»Ì¨µçÄÔÖ÷»ú¿ÉÒÔÓжà¸öÈ«¾ÖÊý¾Ý¿âÂð£¿
·Ç³£¿ÉÒÔ£¡
ÕâÖÖ°ïÖúÎĵµÊDZ¾»ú°²×°µÄʱºò¾Í¸½´øÓе쬻¹ÊÇÒªÖØÐÂÏÂÔØµÄ¡£
²»¹ýÏëÏëÊÇÓ¢Îĵ쬾ÍÓеãÐÄÐéÁË¡£
ÁíÍ⣬×öjdbcÁ´½ÓµÄʱºò£¬Ê¹ÓÃSIDÃû³Æ»¹ÊÇÈ«¾ÖÊý¾Ý¿âÃû°¡¡£
¼ÙÈ磺strConn = "jdbc:oracle:thin:@china-e7ed21b49:1521:abc";
×îºóµÄÓ¦¸ÃÊÇSID Ãû³Æ£¿»¹ÊÇ È«¾ÖÊý¾Ý¿âÃû°¡£¿
ѧjava »¹×öÁËÈýÄê ¿´À´sqlÓï¾ä¶¼Ã»Ê²Ã´ÎÊÌâ
Ö÷ÒªÏÈѧѧÊý¾Ý¿âÌåϵ½á¹¹
www.itpub.net Ê
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......