数据库 Oracle创建表空间及用户

创建临时表空间

CREATE TEMPORARY TABLESPACE FDSS_TEMP
         TEMPFILE 'D:\BLT\FDSS_TEMP.dbf'
         SIZE 1024M
         AUTOEXTEND ON
         NEXT 1024M MAXSIZE UNLIMITED
         EXTENT MANAGEMENT LOCAL;

创建数据表空间

CREATE TABLESPACE FDSS
         LOGGING
         DATAFILE 'D:\BLT\FDSS.dbf'
         SIZE 1024M
         AUTOEXTEND ON
         NEXT 1024M MAXSIZE UNLIMITED
         EXTENT MANAGEMENT LOCAL;

创建用户并制定表空间

CREATE USER FDSS IDENTIFIED BY 123456
         ACCOUNT UNLOCK
         DEFAULT TABLESPACE FDSS
         TEMPORARY TABLESPACE FDSS_TEMP;

给用户授予权限

GRANT CONNECT,RESOURCE TO FDSS;
GRANT DBA TO FDSS;

删除用户

drop user username cascade;