--创建表空间和用户
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 ;