oracle12c迁移到11g,Oracle 11g表迁移到12c

注意：文件存储在服务器本地、目录的创建与授权请系统给权限

-----------------------------------expdp从11g Release

11.2.0.1.0 ​导出表GRID：

创建目录​

CREATE or replace DIRECTORY DP_DIR AS 'E:\app\oradump';

---DROP DIRECTORY

DP_DIR

授权​

GRANT READ,WRITE ON DIRECTORY DP_DIR TO ZJ;

or

grant read, write on directory DP_DIR to public;

执行文件expdp.par

expdp.par内容：

userid=zj/zj1234

directory=dp_dir

dumpfile=zhejiang_grid50.dmp

logfile=zhejiang_grid50.log

tables=zhejiang_grid50

reuse_dumpfiles=y

​----------------------------------------------impdp导入12c

版本Oracle Database 12c Enterprise Edition Release

12.1.0.2.0

创建表空间​

create tablespace ZJ datafile 'E:\ORADATA\ZJ.dbf' size

10240m; ​

创建用户​

create user ZJ identified by "zj1234" default

tablespace ZJ;​

授权

grant dba to

zj;----给执行、登陆权限​就可以了

创建目录​

CREATE or replace DIRECTORY DP_DIR AS

'E:\app\oradump';

---DROP DIRECTORY DP_DIR

授权目录​

GRANT READ,WRITE ON DIRECTORY DP_DIR TO ZJ;

or grant read, write on directory DP_DIR to public;

SELECT * FROM DBA_DIRECTORIES;

impdp导入命令：

impdp ZJ/zj1234

DIRECTORY=DP_DIR  DUMPFILE=grid.DMP

LOGFILE=grizj.log

select count(1)from grid;

commit;​

删除用户​及其表

drop user ZJ cascade;

删除表空间及其数据文件​

drop tablespace ZJ including contents and

datafiles;

​