Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Probleme mit Create View und Recompile
Just a couple of questions or things that might explain the behaviour.
- are the views referencing other objects (views, function) that could
be in an INVALID status, and perhaps the dependant objects are invalid
the first time around.
- are you compiling the objects using the same (owner) schema or a
system schema (for both situation you described).
- does the view text define the schema owner of all objects referenced
in the from clause
HTH Received on Mon Jul 10 2006 - 13:19:16 CDT
![]() |
![]() |