Test Database? 1

[DrSeussFreak]

Does anyone know of a location for a oracle test database similar to SQL Servers Northwinds?

 

[LKBrwnDBA]

If yo have Oracle RDBMS installed, there are some demo schemas (aka M$ db's) you could install.

Find them unde the %ORACLE_HOME%/demo/schema




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[DrSeussFreak]

as I am new to Oracle (coming from SQL Server) how exactly would I install these?

 

[LKBrwnDBA]

When you install Oracle db, it will ask if you want to create the demo database, if you did not choose this option, then:

Using the sql*plus utlility, you execute the provided
scripts.

There are several directories and each has a "demo" schema, for example to create the HR schema:

cd $OH/demo/human_resources
sqlplus system/manager
SQL>@hr_main.sql




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[DrSeussFreak]

thanks!