Andy Hassall <andy@andyh.co.uk> wrote in message news:<74vi10d1iaipf1h0th7mic1rgi6v6nqulb@4ax.com>. ..
> On Thu, 29 Jan 2004 21:25:10 +0000, Andy Hassall <andy@andyh.co.uk> wrote:
>
> >>I'm trying to create some views from an AIX 5.2 64 bit Oracle 9i
> >>database to an AIX 4.3.3 32 bit Oracle 8.1.6 database.
> >>
> >>when I run the create view statement, I get the following:
> >>
> >>SQL> create view scrpei_rec as select * from scrpei_rec@rpsa;
> >>
> >>Warning: View created with compilation errors.
> >>
> >>SQL> show errors;
> >>No errors.
> >>
> >>If I try to delete the view, I get the message that the view does not
> >>exist.
> >>
> >>Any ideas??
> >
> > This is a confirmed bug in Oracle, I remember raising a TAR about it last year
> >sometime. Supposed to be fixed in 9.2.0.5, and 10g.
> >
> > Views with errors against remote objects are not created, even with FORCE
> >option, which is inconsistent with the behaviour of local views and the docs of
> >the FORCE option.
>
> Or to be more accurate:
>
> If you create a view that references remote objects (without FORCE) with
> errors, it claims to have created it with complilation errors: this is
> inconsistent, it should have raised the error that stopped it compiling, as it
> does with local views. And despite it saying it has, it doesn't create an
> INVALID view or populate USER_ERRORS.
>
> If you create it with the FORCE option, it doesn't raise an error, only the
> warning (which is correct). But it doesn't create the view in an INVALID state
> either, which is wrong.

Thanks to everyone for the responses, you've saved me some migraine medicine!!