Wahai Guys,
I created second database using Database Assistant on NT.
There's no error when I create this 2nd DB.
Then I make a host-string name 'dblokal2' for my second database.
I can connect to my second db , but there's an error :
the message written below :
SQL> conn beng/bambang@dblokal2;
READ the screen it tell you what to do:
HINT: > You may need to run PUPBLD.SQL as SYSTEM
Does it get more easier than that?
if you dont understand, break out the documentation and start reading.
joe
Bambang Setiawan wrote:
>
> Wahai Guys,
>
> I created second database using Database
"You may need to run PUPBLD.SQL as SYSTEM"
seems pretty clear to me:
NT inclined:
set oracle_sid=
sqlplus
connect system/manager
@%ORACLE_HOME%\sqlplus\admin\pupbld.sql;
REM @D:\Oracle\Ora81\sqlplus\admin\pupbld.sql
quit
Paul
Bambang Setiawan wrote:
>
> Wahai Guys,
>
> I created second dat
I've tried it...
it works..
but my primary question not only how to fix it but
why this thing happened ?
<> Bambang Setiawan <>
>>> "Joseph S. Testa" <[EMAIL PROTECTED]> 03/07/01 11:35 >>>
READ the screen it tell you what to do:
HINT: > You may need to run PUPBLD.SQL as SYSTEM
Does it
This happened because your new database did not have the
product_user_profile table created with all the relevant info.
It happened because Oracle says it happened, and gave you the route of how
to fix it.
It happened because you didn't run PUPBLD.SQL..
HTH :)
Mark
-Original Message-
Title: RE: error after creating second database
> -Original Message-
> From: Bambang Setiawan [mailto:[EMAIL PROTECTED]]
> Sent: mardi, 6. mars 2001 21:55
>
> but my primary question not only how to fix it but
> why this thing happened ?
>
> >>> &q
run pubbld.sql present in $ORACLE_HOME/sqlplus dir under system account in the second
database
--
On Tue, 06 Mar 2001 19:20:21
Bambang Setiawan wrote:
>Wahai Guys,
>
>I created second database using Database Assistant on NT.
>There's no error when I create this 2nd DB.
>Then I make a host-st
ist ORACLE-L
> Asunto: Re: error after creating second database
>
> run pubbld.sql present in $ORACLE_HOME/sqlplus dir under system account
> in the second database
> --
>
> On Tue, 06 Mar 2001 19:20:21
> Bambang Setiawan wrote:
> >Wahai Guys,
> >
> >