/*创建表空间*/
CREATE TABLESPACE "TRANS"
DATAFILE
'E:\ORADATA\ORCL\TRANS.DBF' SIZE 10485760000
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10485760 DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
/*创建临时表空间*/
CREATE TEMPORARY TABLESPACE "TMP_TRANS"
TEMPFILE
'E:\ORADATA\ORCL\TRANS_TEMP.DBF' SIZE 50 M
AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1 M;
-- Create the user
create user TRANS
identified by trans
default tablespace TRANS
temporary tablespace TMP_TRANS
profile DEFAULT
password expire;
-- Grant/Revoke role privileges
grant connect to TRANS;
grant dba to TRANS;
grant resource to TRANS;
-- Grant/Revoke system privileges
grant create any table to TRANS;
grant create job to TRANS;
grant manage scheduler to TRANS;
grant unlimited tablespace to TRANS;
oracle创建表空间及用户
最新推荐文章于 2022-04-26 15:56:37 发布