sample tables **

[chrissy]

Hello,

Where would i be able to find the sample tables for user scott. The ones i'm looking for are
Customers
Items
Orders
Parts

I was able to find the ones for
EMP
Salgrade,
...

Please help.

Thanks

[kgb]

it is 2 ways:
1) go to the search system http://www.google.com
2) Or download old version of Oracle, which contains all tables
ftp://ftp.rprg.ru/ORACLE73/

[pipo]

look in $ORACLE_HOME/RDBMS/ADMIN/BDEMOBLD.sql

[pareshg]

HI

if u are working on Oracle on Win NT/ 98 then
in find files u type demo*.sql

then it will show no. of files, then open any of the file
which contains customer or sales table., that file u have to execute in sqlplus.
Suppose that file is in c:\orant\dbs and name of the file is demobld.sql
then

login sqlplus with scott/tiger
sqlplus>@c:\orant\dbs\demobld.sql;

then it will create all the tables in scotts schema.

I think this will definately help u

Bye

Originally posted by pipo
look in $ORACLE_HOME/RDBMS/ADMIN/BDEMOBLD.sql

[padmam]

Hi, 21st May 2001 16:11 hrs chennai

Go to search type demobld*.sql you will get lot of tables.

If it is going to oracle 8.1.6 then you can find the following info.

execute from the scott as @D:\oracle8i\oo4o\demobld7.sql which contains the following contents.Normally the file will drop the existing tables and sequences and bld the new ones.

EMP;
DEPT;
BONUS;
SALGRADE;
DUMMY;
ITEM;
PRICE;
PRODUCT;
ORD;
CUSTOMER;
SALES;
ORDID;
CUSTID;
PRODID

If you need to drop the same you search the same for demodrop*.sql

Cheers

Padmam