Tuesday, November 17, 2009

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

No comments:

Post a Comment

Amazon Best Sellors

Weblogic - Server Creation - Issues

Datasource creation using python script.  Python Script was failing after creating Datasource. From UI Admin Console, if I try to activat...