Oracle 创建表空间的命令

CREATE SMALLFILE TABLESPACE "JXKH" DATAFILE 'F:\oracle\product\10.2.0\oradata\temp\JXKH' SIZE 100M AUTOEXTEND ON NEXT 5K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user jxkh identified by jxkh default tablespace jxkh temporary tablespace temp;
grant dba to jxkh;
grant insert any table to jxkh;
grant select any table to jxkh;
grant update any table to jxkh;
grant delete any table to jxkh;
grant select any sequence to jxkh;
grant execute any procedure to jxkh;
grant connect to jxkh;
grant unlimited tablespace to jxkh;

CREATE SMALLFILE TABLESPACE "EXAM" DATAFILE 'F:\oracle\product\10.2.0\oradata\temp\EXAM' SIZE 100M AUTOEXTEND ON NEXT 5K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user exam identified by exam default tablespace exam temporary tablespace temp;
grant dba to exam;
grant insert any table to exam;
grant select any table to exam;
grant update any table to exam;
grant delete any table to exam;
grant select any sequence to exam;
grant execute any procedure to exam;
grant connect to exam;
grant unlimited tablespace to exam;

CREATE SMALLFILE TABLESPACE "BASE" DATAFILE 'F:\oracle\product\10.2.0\oradata\temp\BASE' SIZE 100M AUTOEXTEND ON NEXT 5K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user base identified by base default tablespace base temporary tablespace temp;
grant dba to base;
grant insert any table to base;
grant select any table to base;
grant update any table to base;
grant delete any table to base;
grant select any sequence to base;
grant execute any procedure to base;
grant connect to base;
grant unlimited tablespace to base;

转载于:https://www.cnblogs.com/jasonjiang/archive/2010/07/29/1787633.html