创建表空间
create tablespace JECP
datafile 'E:/orcal/oradata/orcl/JECP.DBF'
size 5000M autoextend on next 50M maxsize unlimited;
创建用户:
create user gic_1160_20230526 identified by gic_1160_20230526 default tablespace JECP temporary tablespace TEMP profile DEFAULT;
用户授权:
grant dba to gic_1160_20230526;
还原数据库:
impdp gic_1160_20230526/gic_1160_20230526@orcl REMAP_SCHEMA=GIC_1160_20230526 DUMPFILE=GIC_1160_20230526_105623.DMP
解锁用户操作: