СµÜÔÚµ¼³öÒ»¸öÊý¾Ý¿âµÄʱºò£¬¿ªÊ¼ºÜ˳Àû£¬µ±±íÈ«²¿µ¼Í꿪ʼµ¼³öË÷ÒýµÄʱºò±¨ÏÂÃæµÄ´í
EXP-00056: ORACLE error 4063 encountered
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBUTIL_INT"
ORA-06512: a ......
2010-05-13 10:29:35,499 [com.mchange.v2.resourcepool.BasicResourcePool] com.mcha
nge.v2.resourcepool.BasicResourcePool$AcquireTask@177fa9a -- Acquisition Attempt
Failed!!! Clearing pending acquires. While trying to acquire a needed new resou
rce, we failed to succeed more than the maximum ......
СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£
ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£
È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£·¢ÏÖ·þÎñÀïʲô·þÎñ¶¼ÓУ¬¾ÍÊÇûÓÐoracleDBConsoleorcl·þÎñ¡£
ÓôÃÆËÀÁË¡£
»á²»»áÊÇ°æ±¾µÄÎÊÌâѽ¡£ÄѵÀÒªÖØ×°£¿ÅµÈÏÂÖØ×°»á¸ü³öÎÊÌ⣬ʲô²ÐÓ ......
¿´ÏÂÃæsqlÓï¾ä£¬ÎÒÏëÓà rw À´ÊµÏÖ´Ón-mµÄ½ØÈ¡
select * from(select times,pages,rownum rw from layouts) where times='20090105' order by pages asc;
½á¹ûÊÇ£º
times pages rw
20090105 A001 96
20090105 A002 97
20090105 A003 98
.
.
Ϊʲôrw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿ÒÔÖÁÓÚÎÒÔÚwhereºóÃæÓà r ......
ÏëÓÃoracleµÄDB Link Á¬½ÓAS400·þÎñÆ÷,°´ÕÕÍøÉÏËù˵ÓÃ͸Ã÷Íø¹Ø·½·¨,µ«ÊÇÔõô¶¼Á¬²»ÉÏAS400·þÎñÆ÷,
ÇóÆäËû·½·¨»ò³É¹¦°¸ÀýÏêϸÉèÖÃ~ллÀ²~
Á¬½Óas400 db2? db2ûÓùý£¬°ï¶¥
Çó½â~~~~~~
ûÓÐÈËÕâÑùÁ¬½Ó¹ýô?°æÖ÷°ïÎÒתµ½DB2¿´¿´°¡~~
{{ ......
ÎÒ´ÓÁíÍâһ̨»ú×ÓÉϵÄoracleÉϵ¼³öÁËÒ»¸öÓû§A£¬µÃµ½A.DMP£¬µ¼³öÊdzɹ¦µÄ¡£ È»ºó£¬ÔÚÎҵĻú×ÓÉϵ¼ÈëÁËoracleÖУ¬ÎÒÔÚÓû§BϽøÐеÄIMPµ¼È룬ÏÔʾ³É¹¦ÖÕÖ¹µ¼È룬ûÓгöÏÖ¾¯¸æ£¬¿ÉÎҵǼµ½BÒÔºó£¬È´Ã»Óз¢ÏÖÓÐÈκε¼ÈëµÄ¶«Î÷£¬ÓÃPL/SQLÒ²¿´²»¼û¡£Çë¸÷λ°ïæָ½Ìһϣ¬Èç¹û²é¿´µ¼ÈëµÄÓû§¡£¼±£¡
exp/imp Óï¾äÔõôдµÄ£¿¡ ......