创建表空间及用户

临时表空间

create temporary tablespace zero_temp tempfile 'd:/oracle/zero/zero_temp.dbf' size 32m autoextend on next 32m maxsize  unlimited  extent management local;

数据表空间

create bigfile tablespace zero_data datafile 'd:/oracle/zero/zero_data.dbf' size 32m autoextend on next 32m maxsize unlimited extent management local;

创建用户

create user zero identified by zero account unlock default tablespace zero_data temporary tablespace zero_temp;

赋予权限

grant connect,resource,dba to zero;

查询所有用户

select * from dba_users;

查询所有临时表空间

select * from dba_temp_files;

查询所有表空间

select * from dba_data_files;

删除用户

drop user 用户名 cascade;

删除表空间或临时空间

drop tablespace  表空间名称  including contents and datafiles cascade constraint;