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;