2021-12-03 oracle数据导入问题总结

sqlplus ls_fhy/123456

create tablespace zztygl

datafile 'D:\oracle\oradata\zztygl\zztygl.dbf'

size 500M autoextend on next 5M maxsize unlimited;

create user zztygl identified by 123456

default tablespace zztygl

temporary tablespace TEMP

profile DEFAULT;

grant dba to zztygl;

grant connect to zztygl;

grant resource to zztygl;

imp zztygl/123456@localhost/orcl file=D:\oracle\zztygl20200401.dmp full=y

alter tablespace  LS_TABLESPACE rename to LY;

select name from v$tablespace;