oracle impdpÎÊÌâ
ÎÒÓÃimpdp µ¼ÈëÊý¾Ýʱ±¨ÏÂÃæ´íÎó:
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_SZ" 108.7 MB 2837822 out of 2837929 rows
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_NJ" 70.66 MB 1883142 out of 1883217 rows
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_WX" 74.40 MB 1931233 out of 1931339 rows
ORA-31693: Table data object "EPMA"."A_ACCT_BAL":"A_ACCT_NT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-14400: inserted partition key does not map to any partition
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_TZ" 62.30 MB 1609448 out of 1609473 rows
ORA-31693: Table data object "EPMA"."A_ACCT_BAL":"A_ACCT_YC" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-14400: inserted partition key does not map to any partition
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_HA" 55.13 MB 1427215 out of 1427223 rows...
.......
Ïà¹ØÎÊ´ð£º
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËƺõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵĻ°,Ê×ÏÈÊÇÒª±ÈÏ ......
#set Oracle User
ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂð£¿
#set Node Name
Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂð£¿
#set the Backup FileName¡¯s date
RQ=¡¯date+%F-%H-%M¡¯ ÕâÊÇÔõ ......
SQL code:
SQL> begin
2 dbms_job.run(24);
3 end;
4 /
begin
dbms_job.run(24);
end;
ORA-12011: ÎÞ·¨Ö´ÐÐ 1 ×÷Òµ
ORA-06512: ÔÚ "SYS.DBMS_IJOB", line 406
ORA-06512: ÔÚ &q ......