在导入的时候,如下:
create or replace directory impdir as 'F:\jhfund';
grant read,write on directory impdir to jhfund;
C:\Documents and Settings\Administrator>impdp jhfund/jhfund directory=IMPDIR du
pfile=funddacc201001210030_%U.dmp REMAP_SCHEMA=jhfund REMAP_TABLESPACE=fundacc:
hfundspa full=y logfile=DATA_PUMP_DIR:jhfund.log
Import: Release 11.1.0.6.0 - Production on 星期日, 19 9月, 2010 17:12:39
Copyright (c) 2003, 2007, Oracle. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: 参数值无效
ORA-39000: 转储文件说明错误
ORA-31640: 无法打开要读取的转储文件 "F:\jhfund\funddacc201001210030_01.dmp"
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
具体如下:
导出脚本(11G):
expdp test109/[email protected] directory=expdp dumpfile=test10930bak.dmp logfile=mydb.log filesize=200m full=y version=10.2.0.1.0
version号一定要哈
导入脚本(10G):
impdp shl1017/shl1017 directory=expdp dumpfile=TEST10930BAK.dmp version=10.2.0.1.0 REMAP_SCHEMA=test109:shl1017
各参数对应的数据你根据自己的修改下哈。
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: 需要权限
ORA-39161: 完整数据库作业需要权限
grant connect,resource,dba to toolbox;
oracle 创建用户并授予dba权限