我在服务器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,
困惑是:执行完了,这个作业还会一直存在吗,会时不时的自动启动吗?
解决方案 »
- 请教各位高手,关于多条件查询的问题
- 函数中插入数据出错
- 为什么我从SQL 2005导出一个表到oracle 10g,在查询的时候提示我 oracle table or view does not exist
- oralce共享服务器模式相关参数设置?
- ==== ORALCE 监听接口,望高手给指条路 ====
- 需要高人指点,insert问题
- 如何知道我的SQLPLUS里面的SESSION设置
- 紧急求助,哪儿有ORACLE 9I简体中文版下载?
- oracle比win2000还烂!
- 启动xp系统,安装Oracle 9i Personl,系统没反应,为何?
- 报表工具(润乾) 出现异常
- 跪求 oracle 11g dba 中文版手册
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