创建表空间：
create tablespace tbs01 datafile '+DATA' size 500M REUSE autoextend on next 10M MAXSIZE Unlimited extent management local autoallocate permanent online;

创建临时表空间：
create temporary tablespace temp_tbs01 tempfile '+DATA' size 200M REUSE autoextend on next 10M MAXSIZE Unlimited extent management local uniform size 256K;

查看表空间情况：
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size  FROM dba_tablespaces t, dba_data_files d WHERE t.tablespace_name = d.tablespace_name GROUP BY t.tablespace_name; 

创建用户：
create user c##hbhe  identified by "wwwwww"   default tablespace tbs01 temporary tablespace temp_tbs01;
grant connect,resource to c##hbhe;
grant dba to c##hbhe;

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle