我们专注攀枝花网站设计 攀枝花网站制作 攀枝花网站建设
成都网站建设公司服务热线:400-028-6601

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决

centos6.6下oracle使用impdp导入数据库报错!

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

创新互联2013年至今,是专业互联网技术服务公司,拥有项目成都网站建设、成都网站设计网站策划,项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命,1280元喀左做网站,已为上家服务,为喀左各地企业和个人服务,联系电话:13518219792

环境:

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.

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


网站栏目:centos6.6下oracle使用impdp导入数据库报错!
链接地址:http://mswzjz.cn/article/pidgij.html

其他资讯