oracle创建表空间和用户 以及彻底删除用户和表空间以及关联数据

--创建表空间和用户
CREATE TABLESPACE TBS_PERM
    LOGGING 
    DATAFILE 'D:/app/Administrator/oradata/fpglqyb/TBS_PERM.DBF' SIZE 50M 
    AUTOEXTEND  ON NEXT  1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL 
    SEGMENT SPACE MANAGEMENT MANUAL;

prompt 建临时表空间
 CREATE 
    TEMPORARY TABLESPACE TBS_PERM_TMP TEMPFILE 'D:/app/Administrator/oradata/fpglqyb/TBS_PERM_TMP.DBF' SIZE 10M 
    AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL 
    UNIFORM SIZE 1M;


prompt 创建用户
CREATE USER perm  PROFILE DEFAULT 
    IDENTIFIED BY perm DEFAULT TABLESPACE TBS_PERM
    TEMPORARY TABLESPACE TBS_PERM_TMP 
    ACCOUNT UNLOCK;

GRANT CONNECT TO perm;
GRANT DBA TO perm;
GRANT CREATE TABLESPACE to perm;
GRANT ALTER TABLESPACE to perm;
GRANT DROP TABLESPACE to perm;
GRANT ALTER ANY INDEX TO perm;

 删除表控件和用户（把关联的都删除掉）

注意 当表空间正在被使用是 是无法删除对应的物理文件..xxx.dbf的，要手动去目录删除

drop user PERM cascade ;
drop tablespace TBS_PERM2 including contents and datafiles cascade constraints ;