Oracle创建表空间及用户

# 查看数据文件路径
select tablespace_name,file_id,bytes/1024/1024,file_name  from dba_data_files order by file_id;

CREATE TEMPORARY TABLESPACE test_TEMP

         TEMPFILE '/opt/oracle/oradata/orcl/test.dmp'

         SIZE 32M

         AUTOEXTEND ON

         NEXT 32M MAxSIZE UNLIMITED

         EXTENT MANAGEMENT LOCAL;
         


         

create tablespace test_DATA
datafile '/opt/oracle/oradata/orcl/test.DBF' 
size 500M
autoextend on 
next 50M maxsize unlimited 
extent management local; 
 
 

create user test
  identified by "123456"
  default tablespace test_DATA
  temporary tablespace test_TEMP
  profile DEFAULT;
grant connect to test;
grant ALL PRIVILEGES to test;
grant unlimited tablespace to test;