SEO

#1 (**permalink**) 02-23-2008, 06:24 AM

Hello,

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??

Best Regards,
Marion Larochelle
Technology Integration Support Analyst
marionl@invera.com

#2 (**permalink**) 02-23-2008, 06:24 AM

Marion wrote:
> Hello,
>
> 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??
>
> Best Regards,
> Marion Larochelle
> Technology Integration Support Analyst
> marionl@invera.com

My guess is one of lack of capitalization ... are there any quote marks
in the SQL you actually ran or the fact that the database link name on
one is not present on the other.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

#3 (**permalink**) 02-23-2008, 06:24 AM

Have tried issuing the following:

select * from scrpei_rec@rpsa;

See if you get any errors.

HTH,
Brian

Marion wrote:
>
> Hello,
>
> 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??
>
> Best Regards,
> Marion Larochelle
> Technology Integration Support Analyst
> marionl@invera.com

--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

#4 (**permalink**) 02-23-2008, 06:24 AM

On 29 Jan 2004 12:36:38 -0800, marionl@invera.com (Marion) 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.

--
Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

#5 (**permalink**) 02-23-2008, 06:24 AM

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.

--
Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

#6 (**permalink**) 02-23-2008, 06:26 AM

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!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode