oracle创建表空间和用户

一点见解

已于 2023-06-29 09:10:14 修改

阅读量94

点赞数

分类专栏： Oracle 文章标签： oracle 数据库 dba

于 2022-06-08 13:16:56 首次发布

本文链接：https://blog.csdn.net/u012593882/article/details/125182570

版权

Oracle 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

CREATE TEMPORARY TABLESPACE FINEDB_TEMP
　　TEMPFILE '/home/oracle/oracle11g/oradata/finedb/finedb_temp.dbf'
　　SIZE 50M
　　AUTOEXTEND ON
　　NEXT 50M MAXSIZE 20480M
　　EXTENT MANAGEMENT LOCAL;

CREATE TABLESPACE FINEDB_DATA
　　LOGGING
　　DATAFILE '/home/oracle/oracle11g/oradata/finedb/finedb.dbf'
　　SIZE 50M
　　AUTOEXTEND ON
　　NEXT 50M MAXSIZE 20480M
　　EXTENT MANAGEMENT LOCAL;

CREATE USER "FINEDB" IDENTIFIED BY "zjc!5YP%ijz9"
　DEFAULT TABLESPACE FINEDB_DATA
　　TEMPORARY TABLESPACE FINEDB_TEMP;

GRANT "CONNECT","RESOURCE" TO "FINEDB";
ALTER USER "FINEDB" QUOTA UNLIMITED ON "FINEDB_DATA";

创建大表空间

CREATE BIGFILE TABLESPACE "FINEDB_BIGDATA" 
    DATAFILE '/home/oracle/oracle11g/oradata/finedb/finedbbigdata.dbf'
	SIZE 100M
	AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
	LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;