Re: How to create the seed database?

On Thu, 09 Oct 2003 06:39:30 +0200, Harald Maier <maierh_at_myself.com> 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.
>

I used dbca to create the sample schemas. But this script is a good alternative. How do I pass passwords for the users? It never prompted for them.

Thanks

>,----
>| SQL> @?/demo/schema/mksample <pw_system> <pw_sys> \
>| <pw_hr> <pw_oe> <pw_pm> <pw_qs> <pw_sh>
>`----
>
>Harald
Received on Fri Oct 10 2003 - 18:46:20 CDT