Oracle创建表空间及用户

最新推荐文章于 2023-03-11 11:27:00 发布

_Zephyrus_

最新推荐文章于 2023-03-11 11:27:00 发布

阅读量118

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/wangxw1803/article/details/95979067

版权

Oracle 专栏收录该内容

35 篇文章 1 订阅

订阅专栏

# 查看数据文件路径
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;