Creating Schema in Oracle Database with Examples

Creating a Schema

The steps detailed below depict the creation of a typical schema within an open instance.

create tablespace ts99 datafile '/data4/ts99.dat'
size 200m default storage ( initial 100k next 100k pctincrease 0) ;

create user user99 identified by pwd99
default tablespace ts99
temporary tablespace temp
quota unlimited on ts99 ;

grant create table,resource,connect to r99 ;

grant dba to r99 ;