Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add SCOTT schema to my database?

696240Apr 20 2010 — edited Oct 23 2012

I found a thread from February in which {user:id=552755} said ({message:id=4083966}):
>
Hello,
To install the SCOTT schema you may execute the following scripts from a DOS box:
set ORACLE_SID=XE
sqlplus /nolog
connect / as sysdba

@<ORACLE_HOME>/rdbms/admin/scott.sql
@<ORACLE_HOME>/sqlplus/demo/demobld.sql
@<ORACLE_HOME>/rdbms/admin/utlsampl.sql

Hope this help.
Best regards,
Jean-Valentin
>

When I tried to do this, I ran the scott.sql file just fine, but the demobld.sql file does not exist in my oraclexe directory. (I do have utlsampl.sql, but have not run it since I haven't run the second file).

Edited by: user11033437 on Apr 20, 2010 9:21 AM ...side question: anyone know why my userid link above didn't work?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2012

Added on Apr 20 2010

2 comments

58,257 views