Re: Probleme mit Create View und Recompile

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 10 Jul 2006 11:19:16 -0700
Message-ID: <1152555556.836461.276900@m79g2000cwm.googlegroups.com>

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