建站
咨询
售后
建站咨询
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.
不知道具体该怎么做，哪位大神指导一下？
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
当前文章：centos6.6下oracle使用impdp导入数据库报错！-创新互联
本文路径：http://scyingshan.cn/article/eihdo.html
