DEMO schema script

goodluck247

Hello

does anyone have the script for the DEMO schema?

Thanks.

sb92075

/home/oracle/app/oracle/product/11.2.0/dbhome_2/inventory/Templates/demo

goodluck247

full path?

goodluck247

never mind, there is no Demo schema script in that folder

Unknown

does anyone have the script for the DEMO schema?

They are included on the installation media. Whether they get installed or not depends on the type of installation you did.

See the Sample Schemas doc

http://docs.oracle.com/cd/B28359_01/server.111/b28328/scripts.htm

About the Scripts

Sample Schemas script directories are located in <span class="codeinlineitalic">$ORACLE_HOME</span>/demo/schema. You must install the Oracle Database Examples media to populate the directories with the Sample Schema scripts. Each schema has two primary scripts:


  The <span class="codeinlineitalic">xx</span>_main.sql script, where <span class="codeinlineitalic">xx</span> is the schema abbreviation, resets and creates all objects and data for a particular schema. This main script calls all other scripts necessary to build and load the schema.
  The script <span class="codeinlineitalic">xx</span>_drop.sql, where <span class="codeinlineitalic">xx</span> is the schema abbreviation, removes all objects from a particular schema.


Sample Schemas script directories are located in the <span class="codeinlineitalic">$ORACLE_HOME/</span>demo/schema directory after completing the Oracle Database Examples installation.

goodluck247

Yes, but I'm talking about the DEMO schema, just one, remember? and  not the demo schemas that are included now...

sb92075

>Yes, but I'm talking about the DEMO schema, just one, remember?

no, not really.

which Oracle version contained this schema?

jgarry

Maybe you need to google:

scott schema

goodluck247

not scott, but DEMO/demo

goodluck247

It was in 10 for sure

sb92075

goodluck247 wrote:

not scott, but DEMO/demo

Contents

Snipe hunt - Wikipedia, the free encyclopedia