Oracle - Creating Database Schema

Schema is contained in tablespace. So very first step is to creating the db schema and aligning to a datafile

create tablespace oracler_tb datafile 'C:\\oracle\\oradata\\oracler_tb.dat' -- datafile to contain schema

size 200m default storage ( initial 100k next 100k pctincrease 0) ;

Creating the schema and its default user

create user oracler identified by sanjeev --user/password to access the schema

default tablespace oracler_tb

temporary tablespace temp

quota unlimited on oracler_tb ;

grant dba to oracler ;

Login into schema

user : oracler@orasid

password : sanjeev