Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Export/Import of Views with function(s) in the GROUP BY Section
>Finally, here's a script to recompile all invalid objects in a schema:
I think Oracle also provides a procedure to do it: DBMS_UTILITY.COMPILE_SCHEMA, or something to that effect... Pass the schema name as the only argument.
![]() |
![]() |