oracle数据泵从11g迁移数据库到12c的PDB(expdp/impdp)

均在服务器端

oracle11g数据导出
–创建目录
先在D盘创建物理路径D:\dump
进入sqlplus

sqlplus / as sysdba

创建逻辑目录

create or replace directory dir as 'D:\dump';

–授权

grant read,write on directory dir to SZGW_YS;

–查询

select * from dba_directories;

退出sqlplus

ctrl+c

–导出

expdp SZGW_YS/SZGW_YS@orcl schemas=SZGW_YS dumpfile=SZGW_YS.dmp DIRECTORY=dir

–删除

drop directory dir;

数据导入Oracle12C
–登录cdb

sqlplus system/cnten as sysdba

–查询当前容器

show con_name

–查询容器中所有pdb

show pdbs

–创建pdb数据库

CREATE pluggable DATABASE pdborcl admin USER pdbadmin identified BY pdbadmin roles=(