Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: invalids objects after export/import
Try
SQL> execute dbms_utility.compile_scehma('SCHEMA_NAME');
The above command at the sql prompt, compiles all the procedures, packages and package bodys in the correct sequence. You should be logged in as the schema owner for the least.
GM
Alexandre Mavel wrote:
> S_at_lut,
>
> I ve done an import from a production database
>
> After the import and the regrants of objects
>
> I exec a procedure to compile invalid objects
> But some objects are still invalid after they are altered!!
> heaven if they are manualy altered
>
> How can i alter them ?
Received on Wed Oct 28 1998 - 08:09:15 CST