> -----Original Message-----
> From: David Jones [mailto:[EMAIL PROTECTED]]
>
> 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
