RE: re-create Scott's schema

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 13 Jun 2001 19:13:16 -0700
Message-ID: <F001.00328C0F.20010613190519@fatcity.com>

> -----Original Message-----
> From: David Jones [mailto:djones1688_at_hotmail.com]
>
> Does anyone know any SQL script to re-create Scott's schema ?

By that, do you mean the demo tables?
When looking for Oracle scripts, it's a good idea to do a search in $ORACLE_HOME/*/admin in particular
$ORACLE_HOME/rdbms/admin

When I searched for "scott" in $ORACLE_HOME/rdbms/admin, I was presented with a list of .sql files. This one looked promising:

$ORACLE_HOME/rdbms/admin/buildall.sql

When I peeked in there, I saw the following statements:

connect internal
...
@@scott.sql
connect internal
@@demo.sql

You can look at scott.sql and demo.sql to figure out what those do.

---

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Wed Jun 13 2001 - 21:13:16 CDT