Oracle 11g create tablespace user name

--Create TABLE space

CREATE tablespace RH_DMRM (table space)

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;

Oracle 11g create tablespace user name