Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÊý¾ÝǨÒÆÎÊÌâ

¹«Ë¾Êý¾Ý¿â·þÎñÆ÷ÊÇÔÚ32λwin2003£¬°²×°ÁË32λµÄoracleÊý¾Ý¿â
ÏÖÓÐÁíһ̨»úÆ÷Ϊ64λwin2003£¬°²×°ÁË64λµÄoracleÊý¾Ý¿â
Èç¹û½«32λ»úÆ÷ÉϵÄÊý¾Ý¿âÊý¾ÝǨÒƵ½64λϵÄoracleÊý¾Ý¿âÖÐ
ÓÃexpdp´Ó32λµÄÊý¾Ý¿âµ¼³öÊý¾Ý,ÓÃimpdpµ¼Èëµ½64λÊý¾Ý¿âÖÐ.

ÒýÓÃ
ÓÃ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µÄ»°¿ÉÒÔÓÃÊý¾Ý±Ã


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracle impdpÎÊÌâ

Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôԭÒò,ÇëÖ¸½Ì....  лл'


Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ