Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why This Objects Are Invalid?
In article <Dafy0UANBbi3Ewl8_at_ahardy.demon.co.uk>,
Andy Hardy <aph_at_ahardy.demon.co.uk> wrote:
> In article <3789A4E0.477B38A2_at_adr.it>, Kekko <dini.f_at_adr.it> writes
> > SQLWKS> select owner,object_name,object_type,status from
> > dba_objects where status = 'INVALID';
>
> What errors do you get when you try to manually compile an object?
>
> Andy
> --
> Andy Hardy. PGP key available on request
> ===============================================================
>
Kekko, Were you logged in as sys when you ran catproc? If so if you
have not built another db using this install have you reviewed the
install logs to be sure the install was totally successful? If it
wasn't you should not have been able to get this far, but it could be
worth a look. The only other thing that comes to mind is when your re-
ran catalog and catproc did you run then in that order?
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jul 12 1999 - 15:48:44 CDT