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

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Óï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËƺõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵĻ°,Ê×ÏÈÊÇÒª±ÈÏ ......

oracle×Ô¶¯±¸·Ý½Å±¾ÉèÖÃÎÊÌâ

#set Oracle User
ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂð£¿
#set Node Name
Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂð£¿
#set the Backup FileName¡¯s date
RQ=¡¯date+%F-%H-%M¡¯  ÕâÊÇÔõ ......

¼±¼±-Oracle¼Æ»®ÈÎÎñ

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ