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
Don't forget to pass the schema name in upper case. It's work fine.
Chris Bigenwald wrote:
>
> >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.
>
> - Chris Bigenwald
-- Valery A. Sorokin ProSoft, Russia, Moscow, Information Systems Division Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640 E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su http://www.dd.ruReceived on Thu Jul 09 1998 - 00:00:00 CDT
![]() |
![]() |