Re: How to create the seed database?

Peter <peter_at_nomorenewspamin.ca> writes:

> 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>
>>`----

Either pass them as arguments or the script will ask you for them.

,----[ Snippet of mksample ]
| PROMPT
| PROMPT specify password for SYSTEM as parameter 1:
| DEFINE password_system = &1
| PROMPT
| PROMPT specify password for SYS as parameter 2:
| DEFINE password_sys = &2
| PROMPT
| PROMPT specify password for HR as parameter 3:
| DEFINE password_hr = &3
| PROMPT
| PROMPT specify password for OE as parameter 4:
| DEFINE password_oe = &4
| PROMPT
| PROMPT specify password for PM as parameter 5:
| DEFINE password_pm = &5
| PROMPT
| PROMPT specify password for all QS schemas as parameter 6:
| DEFINE password_qs = &6
| PROMPT
| PROMPT specify password for SH as parameter 7:
| DEFINE password_sh = &7
| PROMPT
| PROMPT Sample Schema creating will take about 40 minutes to complete...
| PROMPT

`----

Harald Received on Sat Oct 11 2003 - 01:57:02 CDT