数据库表空间的操作

drop user GRID_WORKFLOWDB cascade;
--删除表空间
drop tablespace GRID_WORKFLOWDB
including contents and datafiles;
--创建表空间
CREATE TABLESPACE GRID_WORKFLOWDB 
DATAFILE 'GRID_WORKFLOWDB.DBF' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
PERMANENT
DEFAULT STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645)
MINIMUM EXTENT 64K
LOGGING
ONLINE
/
--创建用户
CREATE USER GRID_WORKFLOWDB
IDENTIFIED BY ydkssa        
DEFAULT TABLESPACE GRID_WORKFLOWDB
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO GRID_WORKFLOWDB WITH ADMIN OPTION
/
GRANT DBA TO GRID_WORKFLOWDB WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO GRID_WORKFLOWDB WITH ADMIN OPTION
/