oracle 9iºÍ10g³åÍ» - Oracle / ¸ß¼¶¼¼Êõ
Á½Ì¨·þÎñÆ÷Ò»¸ö9iµÄÒ»¸ö10µÄ£¬È»ºó¿Í»§¶ËÉÏÓÐÁ½¸öÓ¦ÓóÌÐò,Ò»¸öÒª·ÃÎÊ9iÒ»¸ö·ÃÎÊ10g,
ÏÖÔÚoracleÁ½¸ö°æ±¾µÄ¿Í»§¶Ë¶¼°²×°ÁË£¬µ«ÊÇֻҪʹÓÃÆäÖÐÒ»¸öÓ¦ÓóÌÐòÁíÒ»¸ö¾Í²»ÄÜʹÓÃÁË£¬
ËÖªµÀÕâÊÇÔõô»ØÊ£¬¸ÃÔõô½â¾ö£¿Ð»Ð»
Ò»¸ö¿Í»§¶Ë×ãÒÓ
ÄDZ£ÁôÄĸö¿Í»§¶ËÄØ£¿
Ò»°ã¶¼Óø߰汾µÄ°É
¸ß°æ±¾µÄ¿Í»§¶Ë±£Áô
ÄÇÔÀ´ÐèÒª²Ù×÷9iµÄÓ¦ÓóÌÐò»¹ÄÜÓÃÂð
¿ÉÒÔ ,ÏòϼæÈÝ
ÄÇÇëÎÊÕâÊÇʲôÔÒòÔì³ÉµÄÄØ£¿
ֻҪʵÀýÃû²»Ò»Ñù£¬Ó¦¸Ã¿ÉÒÔ¼æÈݵÄ
ÄÇ10g¿Í»§¶ËÊDz»ÊÇ»¹ÒªÔÙÌí¼ÓÅäÖÃѽ£¿
±£Áô½Ï¸ß°æ±¾µÄ¿Í»§¶Ë¾Í¿ÉÒÔÁË¡£
10g¿Í»§¶ËÐèÒªÔÙ½øÐÐÅäÖÃÂ𣿸ÃÔõôÅäÖã¿
ÕÒtnsnames.ora£¬Á¬½ÓÅäÖö¼ÔÚÕâ¸öÎļþÏÂÃæÄØ¡£
½¨Òé±£ÁôµÍ°æ±¾µÄ¿Í»§¶Ë£¬Èç¹ûÄãÓÃ10g¿Í»§¶ËµÄexpÁ¬½Óµ½9iµÄÊý¾Ý¿â£¬¿ÉÄÜ»á³öÎÊÌâ¡£
ÎÒÕâÀïÁ½¸ö¿Í»§¶Ë¶¼ÄÜÓᣲ»¹ýÒ»°ãÊǸ߰汾µÄ¡£
Èç¹ûʹÓø߰汾µÄimpÏòµÍ°æ±¾µÄÊý¾Ý¿âµ¼ÈëÊý¾Ýʱ£¬¿ÉÄÜ»á³öÈçÏÂÎÊÌ⣺
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
µ±Ê±ÎҵĽâ¾ö°ì·¨ÊǽøÐеͰ汾µÄĿ¼£¬Ê¹ÓõͰ汾µÄimpÃüÁî¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸö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 ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬
ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9
û¿´¶® replaceô
ÊǵÄÒýÓÃ
û¿´¶® replaceô
replace('FM099','9','ÏëÌæ»»³Éµ ......