临时表空间
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;
