oracle创建表空间及用户

 /*创建表空间*/
 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;