我在服务器a上执行:
SQL>create directory dump_dir as 'D:\dump_0210';
SQL>grant read,write on directory dump_dir to hid;
C:\>expdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=a.log tables=t1,t2
得到bak_a.dmp,
然后再在服务器a上执行:SQL> drop user hid cascade;
SQL> grant connect,resource to hid identified by scj;
SQL> alter user hid default tablespace test_space temporary tablespace temp;
SQL> grant read,write on directory dump_dir to hid;
C:\>impdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=c.log table=t1,t2一切都很正常。
然而,我把bak_a.dmp放到服务器b的e:\0210目录下,服务器b上create directory dump_dir as 'e:\0210';
执行上面那段兰色的impdp代码时 ,却报错:ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "e:\0210\bak_a.dmp"
问题:
1,服务器b的导入怎么解决?
2,象上面那样在dos中
每次导入或导出的时候都会出现“作业已于成功完成”,
我在代码中没指定什么作业,我在oem里也没建job,
困惑是:执行完了,这个作业还会一直存在吗,会时不时的自动启动吗?
SQL>create directory dump_dir as 'D:\dump_0210';
SQL>grant read,write on directory dump_dir to hid;
C:\>expdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=a.log tables=t1,t2
得到bak_a.dmp,
然后再在服务器a上执行:SQL> drop user hid cascade;
SQL> grant connect,resource to hid identified by scj;
SQL> alter user hid default tablespace test_space temporary tablespace temp;
SQL> grant read,write on directory dump_dir to hid;
C:\>impdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=c.log table=t1,t2一切都很正常。
然而,我把bak_a.dmp放到服务器b的e:\0210目录下,服务器b上create directory dump_dir as 'e:\0210';
执行上面那段兰色的impdp代码时 ,却报错:ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "e:\0210\bak_a.dmp"
问题:
1,服务器b的导入怎么解决?
2,象上面那样在dos中
每次导入或导出的时候都会出现“作业已于成功完成”,
我在代码中没指定什么作业,我在oem里也没建job,
困惑是:执行完了,这个作业还会一直存在吗,会时不时的自动启动吗?
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "e:\0210\bak_a.dmp"
expdp:SQL>create directory dump_dir as 'D:\dump_0210';SQL>grant read,write on directory dump_dir to hid;C:\>expdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=a.log tables=t1,t2impdp:SQL> drop user hid cascade;SQL> grant connect,resource to hid identified by scj;SQL> alter user hid default tablespace test_space temporary tablespace temp;SQL> grant read,write on directory dump_dir to hid;C:\>impdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=c.log table=t1,t2
SQL>create directory dump_dir as 'D:\dump_0210';
SQL>grant read,write on directory dump_dir to hid;
C:\>expdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=a.log tables=t1,t2
impdp:SQL> drop user hid cascade;
SQL> grant connect,resource to hid identified by scj;
SQL> alter user hid default tablespace test_space temporary tablespace temp;
SQL> grant read,write on directory dump_dir to hid;
C:\>impdp hid/scj directory=dump_dir dumpfile=bak_a.dmp logfile=c.log table=t1,t2