Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Warning: View created with compilation errors.
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_at_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_at_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/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Jan 29 2004 - 15:04:03 CST