oracle11g dmp imp to oracle10g

来源：互联网发布：梅西c罗数据对比编辑：程序博客网时间：2024/05/22 10:57

有一从11g导出的dmp，需要imp 到oracle10g上

1. 将dmp拷贝到下面sql执行结果的目录中

select directory_path from dba_directories where directory_name='DATA_PUMP_DIR';

D:\oracle\product\10.2.0\db_1\admin\orcl\dpdump\

2. 建表空间、建用户、分dba权限

CREATE TABLESPACE user01
NOLOGGING
DATAFILE 'tbsp_01.dbf'
SIZE 100M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL
;
CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE user01;

grant connect to user01;
grant resource to user01;

-- 必需要有dba权限
grant dba to user01;

-- revoke dba from user01;

IMPDP USERID='user01/user01@orcl' directory=DATA_PUMP_DIR dumpfile=user01db.dmp logfile=user01db.log version=10.2.0.1.0 tables=user01.creditlog,user01.servicelog

4. revoke dba from user01;

导入时出现过错误，参考了

impdp ORA-31655错误处理一例：http://www.oracleonlinux.cn/2012/02/impdp-ora-31655/