189 8069 5689

centos6.6下oracle使用impdp导入数据库报错!-创新互联

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

创新互联10多年企业网站制作服务;为您提供网站建设,网站制作,网页设计及高端网站定制服务,企业网站制作及推广,对成都电动窗帘等多个方面拥有丰富的网站制作经验的网站建设公司。

环境:

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.

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

另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。


分享名称:centos6.6下oracle使用impdp导入数据库报错!-创新互联
浏览路径:http://cdxtjz.com/article/eihdo.html

其他资讯