返回顶部
首页 > 资讯 > 数据库 >centos 6.6下oracle使用impdp导入数据库报错!
  • 940
分享到

centos 6.6下oracle使用impdp导入数据库报错!

2024-04-02 19:04:59 940人浏览 安东尼
摘要

oracle小白一个,遇到问题,请各位大神帮忙看看环境:1、Centos6.62、新安装的oracle 11gR23、使用impdp导入其他的数据库报错[oracle@BJ-BoHua-AssetsTest

oracle小白一个,遇到问题,请各位大神帮忙看看

环境:

1、Centos6.6

2、新安装的oracle 11gR2

3、使用impdp导入其他的数据库报错


[oracle@BJ-BoHua-AssetsTest dbbak]$ impdp XXX/XXX123@orcl directory=dump_dir dumpfile=BTHJ_NCDB_20171020_0101.dmp logfile=BTHJ_NCDB_20171020_0101.log remap_schema=bthjzs:bhsw EXCLUDE=USER full=y cluster=N;


Import: Release 11.2.0.1.0 - Production on Mon Oct 23 16:26:27 2017


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-39087: directory name DUMP_DIR is invalid


下面有查询的信息:

PRIVILEGE                                                            DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

READ                                                                   DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

orcl/dpdump/

 

READ                                                                   DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

orcl/dpdump/

 

READ                                                                   DATA_PUMP_DIR

 

PRIVILEGE                                                            DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

/home/oracle/app/oracle/admin/

orcl/dpdump/

 

WRITE                                                                 DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

 

PRIVILEGE                                                            DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

orcl/dpdump/

 

WRITE                                                                 DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

orcl/dpdump/

 

READ                                                                    DPDATA

/data/oradata/orcl/

 

 

PRIVILEGE                                                              DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

WRITE                                                                      DPDATA

/data/oradata/orcl/

 

                                                                                DPUMP_DIR

/data/oradata/orcl/dpump_dir

 

                                                                                IMPDP

/data/dbbak/

 

 

PRIVILEGE                                                                DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

READ                                                                       ORACLE_OCM_CONFIG_DIR

/home/oracle/app/oracle/produc

t/11.2.0/dbhome_1/ccr/state

 

WRITE                                                                        ORACLE_OCM_CONFIG_DIR

/home/oracle/app/oracle/produc

t/11.2.0/dbhome_1/ccr/state

 

PRIVILEGE                                                                 DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

 

                                                                                XMLDIR

/ade/b/2125410156/oracle/rdbms

/xml

 

 

13rows selected.


不知道具体该怎么做,哪位大神指导一下?

您可能感兴趣的文档:

--结束END--

本文标题: centos 6.6下oracle使用impdp导入数据库报错!

本文链接: https://lsjlt.com/news/41209.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

猜你喜欢
软考高级职称资格查询
编程网,编程工程师的家园,是目前国内优秀的开源技术社区之一,形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容,为IT开发者提供了一个发现、使用、并交流开源技术的平台。
  • 官方手机版

  • 微信公众号

  • 商务合作