创建和删除oracle表空间和用户

---分离数据文件
--set serveroutput on
--exec dbms_output.put_line('-------------------正在分离表空间,请稍候...---------------------')
 ALTER tablespace TBS_SGS_DIGICITY_MDS OFFLINE;
---删除表空间及数据文件
--exec dbms_output.put_line('-------------------正在删除表空间以及数据文件,请稍候...---------------------')
 DROP TABLESPACE TBS_SGS_DIGICITY_MDS INCLUDING CONTENTS AND DATAFILES;
 commit;

----创建表空间
--exec dbms_output.put_line('-------------------正在创建表空间,请稍候...---------------------')
 CREATE TABLESPACE TBS_SGS_DIGICITY_MDS
                            LOGGING
                            DATAFILE 'TBS_SGS_DIGICITY_MDS.dbf'
                            SIZE 32M                                                        
                            AUTOEXTEND ON                                                  
                            NEXT 32M MAXSIZE 2048M
                            EXTENT MANAGEMENT LOCAL;

----删除用户及相关对象
--exec dbms_output.put_line('-------------------正在删除用户信息以及与之相关的所有对象,请稍候...---------------------')
 DROP USER SGS_DIGICITY_MDS CASCADE;
 commit;
----创建用户
--exec dbms_output.put_line ('-------------------正在创建用户信息以及相关对象,请稍候...---------------------')
 CREATE USER SGS_DIGICITY_MDS IDENTIFIED BY "sagis"  DEFAULT TABLESPACE TBS_SGS_DIGICITY_MDS;
 GRANT DBA TO SGS_DIGICITY_MDS;
 commit;