用户和表空间操作

--删除用户和表空间

--SS_Test
drop user SS_Test cascade;
drop tablespace SS_Test including contents and datafiles;

--*************************************************************************************************************************************

--创建用户和表空间

--SS_Test
create user SS_Test identified by SS_Test;
grant dba to SS_Test;
create tablespace SS_Test datafile 'E:\oracle\product\10.2.0\oradata\SSPT\SS_Test.dbf' size 10M autoextend on next 10M;
alter user SS_Test default tablespace SS_Test;