oracleÊý¾ÝǨÒÆÎÊÌâ
¹«Ë¾Êý¾Ý¿â·þÎñÆ÷ÊÇÔÚ32λwin2003£¬°²×°ÁË32λµÄoracleÊý¾Ý¿â
ÏÖÓÐÁíһ̨»úÆ÷Ϊ64λwin2003£¬°²×°ÁË64λµÄoracleÊý¾Ý¿â
Èç¹û½«32λ»úÆ÷ÉϵÄÊý¾Ý¿âÊý¾ÝǨÒƵ½64λϵÄoracleÊý¾Ý¿âÖÐ
ÓÃexpdp´Ó32λµÄÊý¾Ý¿âµ¼³öÊý¾Ý,ÓÃimpdpµ¼Èëµ½64λÊý¾Ý¿âÖÐ.
¶ÔÓÚ¿ç°æ±¾µÄÊý¾Ý°áǨ£¬expdp/impdp(10g²ÅÓÐ)£¬ exp/imp ÊǺܺõŤ¾ß¡£
Oracle 10g EXPDPºÍIMPDPʹÓÃ˵Ã÷
http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4674224.aspx
exp imp
¶¼ÊÇ10gµÄ»°¿ÉÒÔÓÃÊý¾Ý±Ã
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл'
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......