Ò»Ö±ÓÃsqlserver ×î½üÏëѧһÏÂoracle£¬
ÔÚÍøÉÏÕÒÁ˵ãÊ飬¶¼ÊÇoracle 10g»òÕßoracle 9i£¬ ²»ÖªµÀÕâÊÇʲôÒâ˼¡£
twin driveÇý¶¯µÄ¸Ø´óľÍÃ×ÓÆ®¹ý...
-----------------»ªÀöµÄ·Ö¸îÏß-----------------
oracle ¼×¹ÇÎÄ lzûÌý˵¹ý?
ÒýÓÃ
oracle ¼×¹ÇÎÄ lzûÌý˵¹ý?
zhidao
sqlserver ......
µ¼Èëpdmʱ±¨
D:\>imp ectrip_dmp/ectrip@orcl file=d:\newjzg.pdm
Import: Release 10.1.0.2.0 - Production on ÐÇÆÚÎå 9ÔÂ 11 10:29:47 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1 ......
#set Oracle User
ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂð£¿
#set Node Name
Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂð£¿
#set the Backup FileName¡¯s date
RQ=¡¯date+%F-%H-%M¡¯ ÕâÊÇÔõô¶¨ÒåµÄʱ¼ä£¿RQÊǵ÷¶Èʱ¼äÉèÖÃÂð£¿
-----------------------------------------
OraUser=¡±ora ......
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎó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 ......
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: ÔÚ "SYS.DBMS_JOB", line 272
ORA-06512: ÔÚ line 2
ʲôÔÒò°¡
run Ç°ÃæµÄÄØ£¿
......
³ÌÐòÔËÐÐÔÚûÓа²×°Oracle¿Í»§¶ËµÄ»úÆ÷ÉÏ£¬Á¬½Óµ½Ô¶³Ì·þÎñÆ÷£¬ÔõôÑù²ÅÄÜÁ¬ÉÏÊý¾Ý¿â£¬±¾µØÐèҪʲôÉèÖûòÕß±ØÐ밲װʲôÇý¶¯Ã´£¬×îºÃÄܲ»°²×°Èκζ«Î÷¡£
Thanks in advance.
µÃ×°¿Í»§¶Ë.ûÇý¶¯Á¬²»ÉϵÄ.
×°Oracle ODBC Çý¶¯
×°ÉÏÇý¶¯
±ØÐë×°,²»×°µÄ»°.¿ÉÒÔ¿¼ÂÇÓÃweb servicesµÈÊÖ¶ÎÈÆһϠ(c/s)
×°ÉÏ ¿ ......