–建立临时表空间 Feiyu_Temp

CREATE TEMPORARY TABLESPACE Feiyu_Temp
  TEMPFILE \’/home/oracle/oradata/orcl/SecurityPlatform_Temp.dbf\’ SIZE 50M AUTOEXTEND
  ON NEXT 32M MAXSIZE 2048M
  EXTENT MANAGEMENT LOCAL;

–建立存储表空间 Feiyu

CREATE TABLESPACE Feiyu
  LOGGING
  DATAFILE \’/home/oracle/oradata/orcl/SecurityPlatform.DBF\’ SIZE 50M AUTOEXTEND
  ON NEXT 51200K MAXSIZE  32767M EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT  AUTO ;

–建立用户 Feiyu / 123456

CREATE USER SecurityPlatform IDENTIFIED BY 123456
DEFAULT TABLESPACE Feiyu
TEMPORARY TABLESPACE Feiyu_Temp;

–赋予 Feiyu 权限

GRANT
    connect,resource,dba,
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
　　TO Feiyu

建表空间的时候需要设置自动增长，否则后面调优很麻烦。

版权声明：本文为flish原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/flish/archive/2010/06/17/1878380.html