【文件属性】:
文件名称:Oracle数据库创建和授权
文件大小:1KB
文件格式:SQL
更新时间:2019-03-09 05:44:39
sql,oracle
- 删除临时表空间及文件
DROP TABLESPACE ELWY_TEMP INCLUDING CONTENTS AND DATAFILES;
-- 创建临时表空间
CREATE TEMPORARY TABLESPACE ELWY_TEMP
TEMPFILE 'E:\DataBase\Oracle\ELWY_TEMP.DBF'
SIZE 100m AUTOEXTEND ON NEXT 50m MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
-- 删除数据表空间及文件
DROP TABLESPACE ELWY_DATA INCLUDING CONTENTS AND DATAFILES;
-- 创建数据表空间
CREATE TABLESPACE ELWY_DATA
DATAFILE 'E:\DataBase\Oracle\ELWY_DATA.DBF'
SIZE 100m AUTOEXTEND ON NEXT 50m MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL;
-- 删除用户
DROP USER ELWY CASCADE;
-- 创建用户
CREATE USER ELWY IDENTIFIED BY "ELWY"
DEFAULT TABLESPACE ELWY_DATA
TEMPORARY TABLESPACE ELWY_TEMP;
-- 用户授权
GRANT CONNECT,RESOURCE TO ELWY;
GRANT UNLIMITED TABLESPACE TO ELWY;