1、创建表空间(因导入dmp超大,且根目录空间不足,表空间挂载在data5磁盘):
CREATE TABLESPACE SSXT DATAFILE '/data5/oracle/oradata/cdb/dzzwpt01.dbf' size 2048m autoextend on next 200m maxsize 26480m extent management local;
(增加一个数据文件,解决ORACLE ORA-01653: unable to extend table 报错)
alter tablespace SSXT add datafile '/data5/oracle/oradata/cdb/dzzwpt02.dbf' size 2048m autoextend on maxsize 20G;
2、创建用户:
create user zhouyuan identified by 12345678 default tablespace SSXT;
授权:
grant connect,resource,dba to zhouyuan;
3、导入oracle命令( SSXT_20170928.DMP 放在DATA_PUMP_DIR对应的目录下):
impdp zhouyuan/12345678@ip:port/cdb directory=DATA_PUMP_DIR dumpfile=SSXT_20170928.DMP remap_schema=zhouyuan:zhouyuan;
3、查看oracle数据库的编码
CREATE TABLESPACE SSXT DATAFILE '/data5/oracle/oradata/cdb/dzzwpt01.dbf' size 2048m autoextend on next 200m maxsize 26480m extent management local;
(增加一个数据文件,解决ORACLE ORA-01653: unable to extend table 报错)
alter tablespace SSXT add datafile '/data5/oracle/oradata/cdb/dzzwpt02.dbf' size 2048m autoextend on maxsize 20G;
2、创建用户:
create user zhouyuan identified by 12345678 default tablespace SSXT;
授权:
grant connect,resource,dba to zhouyuan;
3、导入oracle命令( SSXT_20170928.DMP 放在DATA_PUMP_DIR对应的目录下):
impdp zhouyuan/12345678@ip:port/cdb directory=DATA_PUMP_DIR dumpfile=SSXT_20170928.DMP remap_schema=zhouyuan:zhouyuan;
3、查看oracle数据库的编码