Re: Get more practice tables

From: John Russell <netnews4_at_johnrussell.mailshell.com>
Date: Sun, 01 Sep 2002 20:11:00 GMT
Message-ID: <0hs4nucf5odci4efl03apedrop2h2tvcam@4ax.com>

On Sun, 1 Sep 2002 12:43:56 -0400, "Kate" <xkate12_at_yahoo.com> wrote:

>Hi there,
>
>I wonder if I can create more practice tables by runing Oracle's scripts
>like scott.sql after an installation. Currently I have four tables like EMP,
>DEPT in Scott's schoma.
>Any help is appreciated.

Not sure what release you're running. In 9i, there are a bunch of new practice schemas like HR (similar to SCOTT but with extra tables, foreign keys, etc.), OE (order entry), SH (sales history, for data warehousing).

There's a book in 9i explaining about these new schemas:

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96539/toc.htm

John Received on Sun Sep 01 2002 - 15:11:00 CDT