Oracle Database Discussions

Hello everybody !

I'm hoping some kind soul can help out this SQL newbie.
First of all i've installed 10g R2 database on a PC running XP SP2.

Oracle is installed on the root C: drive

I'm using the SQL Fundamentals I Exam Guide and DBA Handbook (Both Oracle Press)
as my reference.

My problem is this.

I installed the DB and created the demo HR schema without too much problem
but it's the demo OE schema i'm having problems getting running and cannot
find anywhere on the net that outlines a step by step SQL process.

I am using SQL Plus to execute these commands.


My questions are these:

-For the default tablespace i specify "users" ?

-What do i specify for the temporary tablespace ? "temp" ?

-what directory path do i put for the data files as parameter 6 ?

I put down "C:\oracle\product\10.2.0\db_1\demo\schema\order_entry" but i suspect it's
the wrong thing ?

-What do i specify for the writable directory path for the log files ?

Is it C:\oracle\product\10.2.0\RDBMS\log

-And what is "Specify version as parameter 8:" line ?

I assumed it was the db version but i believe it's wrong.


Could somebody please help me ? I've already done my CCNA and i wanted to add oracle under my belt.
I know if i had these few things cleared up for me it would pave the way to actually enjoying learning Oracle :)

Thank you for any assistance :)