Oracle：创建表空间、用户、数据导入

• 创建表空间

create tablespace ADCELV 
logging  datafile 'D:\A-WorkSofts\Oracle\db_data\orcl\ADCELV.dbf' 
size 50m  autoextend on  next 50m maxsize unlimited  extent management local; 

• 创建用户

create user adcelv identified by adcelv default  tablespace ADCELV;

• 赋予用户权限

grant connect,resource,dba to adcelv; 

• 导入

imp adcelv/adcelv@127.0.0.1:1521/orcl file=D:\DMP\master_20221208.dmp full=y;