ORACLE 数据表创建步骤

1.创建临时表空间
CREATE TEMPORARY TABLESPACE Test_temp
TEMPFILE 'E:\Test\TEST_temp.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
2.创建用户表空间
create tablespace TEST
datafile 'E:\TEST\TEST.dbf'
size  100M
autoextend on maxsize      200M
extent management local uniform size  64K;
3.创建用户并制定表空间
CREATE USER TEST  IDENTIFIED BY TEST
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE TEST_temp
profile DEFAULT;
 
GRANT UNLIMITED TABLESPACE TO TEST;
 
4.给用户授予权限
        GRANT
　　    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 TEST;
5.创建角色
CREATE ROLE "TestRole" NOT IDENTIFIED;
GRANT "CONNECT" TO "TestRole";
GRANT "DBA" TO "TestRole";
GRANT "RESOURCE" TO "TestRole";
6.授予角色
 GRANT DBATO TEST;
   ALTER USER TEST QUOTA 100M ON TEST;
      GRANT UNLIMITED TABLESPACE TO TEST;