创建表空间，用户

d846674104

于 2014-12-02 10:12:41 发布

阅读量460

点赞数

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/dxjblog/article/details/41674935

版权

数据库专栏收录该内容

2 篇文章

订阅专栏

CREATE TABLESPACE EXLIDB_DATA DATAFILE
F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_DATA.dbf'
SIZE 10M AUTOEXTEND ON NEXT 512k MAXSIZE UNLIMITED;

CREATE TABLESPACE EXLIDB_IMAGE DATAFILE
F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_IMAGE.dbf'
SIZE 10M AUTOEXTEND ON NEXT 512k MAXSIZE UNLIMITED;

CREATE TABLESPACE T_EXLIDB DATAFILE
F:\app\Administrator\oracle_tablespace\EXLIDB\T_EXLIDB.dbf'
SIZE 10M AUTOEXTEND ON NEXT 512k MAXSIZE UNLIMITED;

CREATE TABLESPACE EXLIDB_INDEX DATAFILE
F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_INDEX.dbf'
SIZE 10M AUTOEXTEND ON NEXT 512k MAXSIZE UNLIMITED;

CREATE TEMPORARY TABLESPACE EXLIDB_TEMP tempFILE
F:\app\Administrator\oracle_tablespace\EXLIDB\EXLIDB_TEMP.dbf'
SIZE 10M AUTOEXTEND ON NEXT 512k MAXSIZE UNLIMITED;

--建立用户
CREATE USER "EXLIDB" IDENTIFIED BY "EXLIDB"
DEFAULT TABLESPACE EXLIDB_USER
TEMPORARY TABLESPACE EXLIDB_TEMP;
GRANT CONNECT TO EXLIDB;
GRANT DBA TO EXLIDB;