Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid objects
try
execute dbms_utility.compile_schema('SYS')
Pinchas Nisenson <nisenson_at_acs.ucalgary.ca> wrote in article
<61bo72$n3q_at_ds2.acs.ucalgary.ca>...
> I just finished building a database. After checking for invalid
> objects I found dbms that DBMS_SNAPSHOT is invalid.
> Looked it up it said that dbmssnap.sql and prvtsnap.plb have to
> be run.
> I did so and got more errors. That I decided to rerun catalog.sql
> + catdbsyn.sql
> hoping to get rid of errors alas I got even more invalid objects.
>
Received on Tue Oct 07 1997 - 00:00:00 CDT