创建表空间

DROP TABLESPACE test   INCLUDING CONTENTS AND DATAFILES;--删除表空间

drop user test cascade;

select   *   from   dba_tablespaces--查看表空间

 

--创建表空间
create tablespace test
datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\test.dbf' size 20M       
autoextend on next 20M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
commit;

--创建用户
CREATE USER test
IDENTIFIED BY test
DEFAULT TABLESPACE test
TEMPORARY TABLESPACE TEMP;
commit;

--分配角色
grant connect to test;
grant dba to test;