Oracle Êý¾Ý¿â»Ö¸´ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÏÖÔÚÓÐÒ»Êý¾Ý¿â·þÎñÆ÷£¬×°µÄÊÇ10G£¬ÁíÒ»·þÎñÆ÷£¬×°µÄÊÇ9i ÏÖÔÚ´Ó10GÖб¸·ÝµÄÎļþÄܲ»Äָܻ´µ½9iÖУ¬Ó¦¸Ã×¢ÒâÄÄЩ¶«Î÷£¿
ÓÃÂß¼µ¼³ö°É,ʹÓÃ9iµÄ¿Í»§¶ËÁ¬½Ó10g£¬expÊý¾Ý¡£È»ºóʹÓÃ9i¿Í»§¶Ëimpµ½9iÊý¾Ý¿âÖС£ 1Â¥ Õý½â£» Ò²¿ÉÒÔµ¼³ösql»ù±¾Ã»Ê²Ã´ÎÊÌ⣬Èç¹ûÊÇjobʲôµÄ¿ÉÒÔÊÖ¶¯½¨¡£ÆäËûûʲôעÒâµÄ »¹ÊÇÂß¼µ¼³ö±È½ÏºÃ£¬°²È«ÐԸߣ¬¿É²Ù×÷ÐÔÇ¿£¡ÒýÓà ÎÒÏÖÔÚÓÐÒ»Êý¾Ý¿â·þÎñÆ÷£¬×°µÄÊÇ10G£¬ÁíÒ»·þÎñÆ÷£¬×°µÄÊÇ9i ÏÖÔÚ´Ó10GÖб¸·ÝµÄÎļþÄܲ»Äָܻ´µ½9iÖУ¬Ó¦¸Ã×¢ÒâÄÄЩ¶«Î÷£¿ ´Ó10g µ¼Èëµ½9i ¿ÉÄÜ»á³öÏÖÎÊÌ⣬ ÒòΪ10gÖеÄһЩ¶ÔÏó£¬ÔÚ9i ÖÐûÓÐ. ûÓÐÕâÑùµ¼¹ý£¬Â¥Ö÷¿ÉÒÔÓÃ1Â¥µÄ·½·¨ÊÔÊÔ¡£ µ¼Èë֮ǰעÒâϱí¿Õ¼ä´óС¾Í¿ÉÒÔÁË¡£ ÆäËûµÄûÓÐɶÁË. ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 exp/impºÃÐÖµÜÒýÓà ÓÃÂß¼µ¼³ö°É,ʹÓÃ9iµÄ¿Í»§¶ËÁ¬½Ó10g£¬expÊý¾Ý¡£È»ºóʹÓÃ9i¿Í»§¶Ëimpµ½9iÊý¾Ý¿âÖС£ ͬÒâһ¥¿´·¨ 1Â¥ÊÇÕý½â Âß¼µ¼³ö 9 -> 10 ûÎÊÌâ 10 -> 9 »áÓÐÎÊÌâµÄ,¹Ù·½¼¼Êõ×ÊÁÏÉÏ˵²»¿ÉÒÔ Ò»£º½¨ÒéÔÚÁíÒ»¸öoracle 10 g µ¼Èëºó£¬ÓÃsql server µ¼Èëµ¼³öµ½sql server ÖÐ µ¼Èëoracle 9i ÖÐ ¶þ£º½¨Ò
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......