网创优客建站品牌官网
为成都网站建设公司企业提供高品质网站建设
热线:028-86922220
成都专业网站建设公司

定制建站费用3500元

符合中小企业对网站设计、功能常规化式的企业展示型网站建设

成都品牌网站建设

品牌网站建设费用6000元

本套餐主要针对企业品牌型网站、中高端设计、前端互动体验...

成都商城网站建设

商城网站建设费用8000元

商城网站建设因基本功能的需求不同费用上面也有很大的差别...

成都微信网站建设

手机微信网站建站3000元

手机微信网站开发、微信官网、微信商城网站...

建站知识

当前位置:首页 > 建站知识

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://bjjierui.cn/article/eihdo.html

其他资讯