error after creating second database

2001-03-06 Thread Bambang Setiawan
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;

Re: error after creating second database

2001-03-06 Thread Joseph S. Testa
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

Re: error after creating second database

2001-03-06 Thread Paul Drake
"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

Re: error after creating second database

2001-03-06 Thread Bambang Setiawan
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

RE: error after creating second database

2001-03-07 Thread Mark Leith
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-

RE: error after creating second database

2001-03-07 Thread Jacques Kilchoer
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

Re: error after creating second database

2001-03-07 Thread C.S.Venkata Subramanian
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

RE: error after creating second database

2001-03-08 Thread Trassens, Christian
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, > > > >