Scott schema script

[Huu Tai]

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]

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]

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]

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]

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]

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 -