Scott schema script

746 views
Skip to first unread message

Huu Tai

unread,
Nov 14, 2009, 7:43:26 AM11/14/09
to ORACLE_DBA_EXPERTS
I'm using Oracle 10g Express Edition, but I can't find Scott schema. I
really need Scott schema to study and practise. Can you give me SCOTT
schema script ?

ddf

unread,
Nov 14, 2009, 12:40:34 PM11/14/09
to ORACLE_DBA_EXPERTS
It's not the SCOTT schema, it's the demo tables script and these
tables can be owned by any user. Look in $ORACLE_HOME/sqlplus/demo;
you should find the demobld.sql script.


David Fitzjarrell

jgar the jorrible

unread,
Nov 16, 2009, 12:57:15 PM11/16/09
to ORACLE_DBA_EXPERTS
Hmmmm. I see a demo.sql there, but it calls a bdemobld.sql, which
neither it nor myself can find anywhere. Nor is there a demobld.sql.
This is XE 10g on XP I downloaded within the last couple of months.
Do we need to get this from other editions? Bug?

jg
--
@home.com is bogus.
"You people born in the '70s don't know how to party." - drunk caller
on radio at 8:00AM

ddf

unread,
Nov 16, 2009, 1:30:36 PM11/16/09
to ORACLE_DBA_EXPERTS
Look in $ORACLE_HOME/rdbms/admin at the utlsampl.sql script; it should
be the replacement for the old demobld.sql script included with
earlier releases of Oracle. I've read that the SCOTT schema is slated
to be discontinued.


David Fitzjarrell

jgar the jorrible

unread,
Nov 16, 2009, 1:44:55 PM11/16/09
to ORACLE_DBA_EXPERTS
That works much better. I had thought all the HR etc stuff had
replaced it long ago, but haven't looked in a very long time (or at
all at XE).

Thanks!

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2009/nov/16/un-defends-removal-of-china-poster-at-net-event/

Huu Tai

unread,
Dec 15, 2009, 11:33:04 AM12/15/09
to ORACLE_DBA_EXPERTS
I found it on Oracle's website. Thanks you very much !!!

On 17 Tháng Mười Một, 01:44, jgar the jorrible <joel-ga...@home.com>
> @home.com is bogus.http://www.signonsandiego.com/news/2009/nov/16/un-defends-removal-of-...- Ẩn nội dung trích dẫn -
>
> - Hiển thị văn bản được để trong dấu trích dẫn -
Reply all
Reply to author
Forward
0 new messages