oracle impdpÎÊÌâ
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл' Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-39016: Operation not supported when job is in EXECUTING state. . . imported "EPMA"."A_ACCT_ENTRY":"A_ACCT_NJ"."A_ACCT_NJ_PART_0811" 3.338 GB 26075542 out of 26648382 rows
ÒýÓà Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл' Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-39016: Operation not supported when job is in EXECUTING state. . . imported "EPMA"."A_ACCT_ENTRY":"A_ACCT_NJ"."A_ACCT_NJ_PART_0811" 3.338 GB 26075542 out of 26648382 rows ʲôÒâ˼? ²»¶®! ÄѵÀÊÇͬһ¸ö½Å±¾Öظ´Ö´ÐÐÁË?ÒýÓà ÌáʾÒѾºÜÃ÷ÏÔÁ˰¡£¬¸ü¸ÄÈÎÎñÖ´ÐÐ״̬¾ÍÐа¡£¡£¡£¡ ʲôÒâ˼? ²»¶®! ÄѵÀÊÇͬһ¸ö½Å±¾Öظ´Ö´ÐÐÁË?
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼ ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ² SQL code:
......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô? 2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8). ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ. ²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô? Äĸö»Ø¸öÌ ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺ δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......