sample tables **
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: sample tables **

  1. #1
    Join Date
    Oct 2000
    Posts
    56
    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

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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/

  3. #3
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    look in $ORACLE_HOME/RDBMS/ADMIN/BDEMOBLD.sql

  4. #4
    Join Date
    May 2001
    Location
    London
    Posts
    149

    Wink

    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

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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
  •  



Click Here to Expand Forum to Full Width