cancel
Showing results for 
Search instead for 
Did you mean: 

how to set up the sample DB

SOLVED
Go to solution
Danny Pogi
Advisor

how to set up the sample DB

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
5 REPLIES
Christian Gebhardt
Honored Contributor

Re: how to set up the sample DB

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
Advisor

Re: how to set up the sample DB

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

danny
T G Manikandan
Honored Contributor

Re: how to set up the sample DB

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
Honored Contributor
Solution

Re: how to set up the sample DB

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
Advisor

Re: how to set up the sample DB

gotcha!!!!! thanks guys

cheers,
danny