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ÃüÁî¡£
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......