oracle 创建表空间和用户

alter  tablespace xx  offline;


drop tablespace xx including contents and datafiles ;


drop user xx ;


create tablespace tp datafile 'C:\df.dmp' size 1G autoextend on next 10m maxsize unlimited
default storage (initial 128kb next 1m pctincrease 0);


select * from dba_tablespaces;


create user us
identified by pass 
default tablespace tp 
temporary tablespace temp 
profile default ;
 
grant connect to us;
grant resource to us;
grant dba to us;
grant unlimited tablespace to us;






host imp username/password@examplename  file=path.dmp log=path.log full=y;