首页 新闻 搜索 专区 学院

oracle xshell 导出dmp文件失败

0
悬赏园豆:30 [待解决问题]

导出命令:exp njjyc/Njyc2019ikl$ file=202103030924.dmp log=exp202103030924.log(服务名已通过export ORACLE_SID=erp指定)

错误如下:

求教改如何修改命令正确导出?

天地无极,乾坤剑法的主页 天地无极,乾坤剑法 | 初学一级 | 园豆:164
提问于:2021-03-03 09:53
< >
分享
所有回答(1)
0

You may try:
Below works under Solaris10+Oracle11g
bash-3.2$ exp scott/tiger file=/export/home/oracle/exp/scott.dmp tables=emp_dump, dept_dump

You may also try:
bash-3.2$ expdp scott/tiger parfile=/export/home/oracle/exp/scott_par.txt

You may need this:
SQL> grant read,write on directory DATA_PUMP_DIR to scott;

If above did not ring a bell, you may need to have further detailed information, like Oracle,linux version, or further warning message if there is any posted.

blogger2020 | 园豆:207 (菜鸟二级) | 2021-03-03 11:36
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册