Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create the seed database?
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 Received on Wed Oct 08 2003 - 23:39:30 CDT