Amazon

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

TOGAF 9.2 - STUDY [ The Open Group Architecture Framework ] - Chap 01 - Introduction

100 Feet View of TOGAF  What is Enterprise? Collection of Organization that has common set of Goals. Enterprise has People - organized by co...