Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Warning: View created with compilation errors.
Have tried issuing the following:
select * from scrpei_rec_at_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_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
-- =================================================================== Brian Peasland dba_at_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"Received on Thu Jan 29 2004 - 15:12:55 CST