oracle 创建表空间及用户

1.创建临时表空间

create temporary tablespace tvmr_tmp tempfile '/u01/app/oracle/oradata/orcl/tvmr_temp01.dbf' size 256m autoextend on next 256m maxsize 4096m extent management local;

2.创建表空间

create tablespace tvmr logging datafile '/u01/app/oracle/oradata/orcl/tvmr_data01.dbf' size 256m autoextend on next 256m maxsize 4096m extent management local;

3.创建用户

 create user tvmr_oper identified by tvmr_oper default tablespace tvmr temporary tablespace tvmr_tmp;

4.授权用户

 grant connect,resource to tvmr_oper;

5.删除表空间

 drop tablespace tvmr_tmp including contents and datafiles;

6.删除用户以及用户所有的对象 

drop user  tvmr_oper cascade;