-
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
-
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/
-
look in $ORACLE_HOME/RDBMS/ADMIN/BDEMOBLD.sql
-
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
-
Solution
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|