删除用户及数据库，用于重新导入新数据库
drop user hyscm cascade;
创建表空间
create tablespace HYSCM_DATA logging datafile 'E:HYSCM_TESTHYSCM_CS.dbf' size 1024m autoextend on next 200m
创建用户并授权
create user hyscm identified by huscm123 default tablespace hyscm_data;
grant dba to hyscm;
导入
imp hyscm/huscm123@hyscmnew file=E:/hyscm_2020712_1.dmp full=y ignore=n
导出
exp hyscm/huscm123@hyscmnew owner=hyscm file=E:data_backuphyscm_2020713_1.dmp log=e:data_backuphyscm_20200713_1.log