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)