oracle 导入 dmp

 创建空间 

create tablespace gpr
datafile 'D:\workplace\z_oracle_namespace\gpr.dbf' size 100M
autoextend on
next 10M maxsize 5120m
extent management local;
 创建临时空间 
create temporary tablespace gpr_tmp
tempfile 'D:\workplace\z_oracle_namespace\gpr_tmp.dbf'
size 50m
autoextend on
next 80m maxsize 100m;

创建用户

 create user cs_element  identified  by  1        default tablespace gpr       temporary tablespace gpr_tmp; 

create user cs_frame  identified  by  1        default tablespace gpr       temporary tablespace gpr_tmp; 

create user cs_frs   identified  by  1        default tablespace gpr       temporary tablespace gpr_tmp; 

 create user  cs_logger  identified  by  1        default tablespace gpr       temporary tablespace gpr_tmp;  

 create user cs_workflow  identified  by  1       default tablespace gpr       temporary tablespace gpr_tmp; 

 create user  nkpt   identified  by  1       default tablespace gpr       temporary tablespace gpr_tmp; 

 用户授权

grant CONNECT ,RESOURCE ,dba to cs_element  ;

grant CONNECT ,RESOURCE ,dba to cs_frame    ;

grant CONNECT ,RESOURCE ,dba to  cs_frs   ;

grant CONNECT ,RESOURCE ,dba to cs_logger  ;

grant CONNECT ,RESOURCE ,dba to  cs_workflow  ;

grant CONNECT ,RESOURCE ,dba to  nkpt   ;

数据导入  

导入命令，必须在dos 命令行中执行，而不是sqlplus 下执行。

imp cs_element/1@127.0.0.1/orcl18c file=E:\everyDayFile\20230315\dumpfile\cs_element20230314.dmp  log=D:\cs_element.log FULL=y;

imp cs_frame/1@127.0.0.1/orcl18c  file=E:\everyDayFile\20230315\dumpfile\cs_frame20230314.dmp  log=D:\cs_frame.log FULL=y;

imp cs_frs/1@127.0.0.1/orcl18c  file=E:\everyDayFile\20230315\dumpfile\cs_frs20230314.dmp  log=D:\cs_frs.log FULL=y;

imp cs_logger/1@127.0.0.1/orcl18c  file=E:\everyDayFile\20230315\dumpfile\cs_logger20230314.dmp  log=D:\cs_logger.log FULL=y;

imp cs_workflow/1@127.0.0.1/orcl18c  file=E:\everyDayFile\20230315\dumpfile\cs_workflow20230314.dmp  log=D:\cs_workflow.log FULL=y;

imp nkpt/1@127.0.0.1/orcl18c  file=E:\everyDayFile\20230315\dumpfile\nkpt0314.dmp  log=D:\nkpt.log FULL=y;