Re: invalids objects after export/import

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Wed, 28 Oct 1998 12:07:25 +0100
Message-ID: <716u15$552$1@sunrise.pg.gda.pl>

Alexandre Mavel wrote in message <716s4r$ktg$1_at_aristote.pratique.fr>...
>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 ?

Probably they're dependent on objects owned by sys. Export utility does not include sys objects (and its grants) so you must give apropriate grants manually.

HTH,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Wed Oct 28 1998 - 05:07:25 CST