Oracle11g创建表空间

查看表空间默认存放信息
select * from dba_data_files;

查看当前的临时表空间信息
select * from v$tempfile

创建数据表空间
create tablespace LICENSE_DATA_ANALYSICS datafile 'E:\APP\ADMINISTRATOR\ORADATA\FORCL\LICENSE_DATA_ANALYSICS.DBF' size 50M autoextend on next 50M  maxsize unlimited extent management local;

删除表空间
DROP TABLESPACE LICENSE_DATA_ANALYSICS INCLUDING CONTENTS AND DATAFILES;

创建临时表空间
create temporary tablespace LICENSE_DATA_ANALYSICS_TEMP tempfile 'E:\APP\ADMINISTRATOR\ORADATA\FORCL\LICENSE_DATA_ANALYSICS_TEMP.DBF' size 50M autoextend on next 50M  maxsize unlimited extent management local;

创建用户并绑定表空间
create user licensedataanalysis identified by licensedataanalysis
default tablespace LICENSE_DATA_ANALYSICS
temporary tablespace LICENSE_DATA_ANALYSICS_TEMP;

授权用户权限
grant connect,resource,dba to licensedataanalysis;