Re: How to create the seed database?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 09 Oct 2003 15:29:01 +1000
Message-ID: <3f84f2ac$0$30614$afc38c87@news.optusnet.com.au>

Harald Maier wrote:

> Peter <peter_at_nomorenewspamin.ca> writes:
> 

>> On Wed, 08 Oct 2003 01:01:24 +0200, Sybrand Bakker
>> <gooiditweg_at_sybrandb.nospam.demon.nl> wrote:
>>
>>>On Tue, 07 Oct 2003 22:11:34 GMT, Peter <peter_at_nomorenewspamin.ca>
>>>wrote:
>>>
>>>>But, is there a way to install the seed database using the Oracle
>>>>Installer or whatever without reinstalling Oracle?
>>>>
>>>>Thanks.
>>>
>>>HR is NOT a database it is a SCHEMA. That said, there is probably a
>>>script in $ORACLE_HOME/rdbms/admin or $ORACLE_HOME/sqlplus/admin which
>>>will create the schema for you. The exact names of the script are in
>>>the piece of information you have never learned to read before
>>>posting: the FM
>>
>> I have read the manual several times but I just could not find the
>> exact script to run.

> 
> To install the sample schemas use the following script. You should
> pass passwords for system, sys and the other schemas: hr, oe, pm, qs, sh.
> 
> ,----
> | SQL> @?/demo/schema/mksample <pw_system> <pw_sys> \
> |        <pw_hr> <pw_oe> <pw_pm> <pw_qs> <pw_sh>
> `----
> 
> Harald

You can also add in the sample schemas to an existing database by using the database configuration assistant (dbca).

And you get to choose which ones you want, too.

Regards
HJR

-- 
--------------------------------------------
See my brand new website, soon to be full of 
new articles: www.dizwell.com.
Nothing much there yet, but give it time!!
--------------------------------------------

Received on Thu Oct 09 2003 - 00:29:01 CDT