--创建表空间
CREATE TABLESPACE RH_DMRM(表空间)
datafile ‘G:\Oracle\data\dmrm1.dbf‘ size 800M reuse autoextend on next 5M maxsize unlimited,
‘G:\Oracle\data\dmrm2.dbf‘ size 20M reuse autoextend on next 5M maxsize unlimited,
‘G:\Oracle\data\dmrm3.dbf‘ size 20M reuse autoextend on next 5M maxsize unlimited,
‘G:\Oracle\data\dmrm4.dbf‘ size 20M reuse autoextend on next 5M maxsize unlimited,
‘G:\Oracle\data\dmrm5.dbf‘ size 20M reuse autoextend on next 5M maxsize unlimited
LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON;
-- Create the user
create user C##DMRM identified by "DMRM" default tablespace RH_DMRM temporary tablespace temp;
-- Grant/Revoke role privileges
grant connect to C##DMRM; grant resource to C##DMRM; grant dba to C##DMRM;
原文：http://www.cnblogs.com/ls-Aimee/p/4689967.html