how to set up the sample DB

[Danny Pogi]

hi guys,

i just installed oracle rdbms from my d-class box. i would like to practice my SQL and would like to make use of the sample database....the one owned by SCOTT if i have not mistaken...would you help me set it up please.... thanks

regards,

danny

[Christian Gebhardt]

Hi
Do you want to create a database or create schema scott in an existing database ?

To create schema scott with example tables you have to run script:
$ORACLE_HOME\sqlplus\demo\demobld.sql

Creating a database is not so easy and you'll need help from a DBA.

Chrisjavascript:answerFormSubmit()
submit

[Danny Pogi]

thanks christian, thats actually what i want...after executing the script how do i start it up....database instance?

danny

[T G Manikandan]

you can create a database using the

$ORACLE_HOME/bin/dbassist

This is a GUI way of database creation.create a database with everything as defaults.

Also check this link for some help

http://www.vi.unizh.ch/oracle8i_816/onlinedocu/doc/server.816/a76956/create.htm#1656



Thanks

[Christian Gebhardt · Accepted solution]

Danny

just login into the database with sqlplus as any user and start the script: start <$ORACLE_HOME>/sqlplus/demo/demobld.sql

after that you can use this tables:

select * from emp;
select * from dept;
....

Chris

[Danny Pogi]

gotcha!!!!! thanks guys

cheers,
danny