Warning: View created with compilation errors.

Giganews Newsgroups
Subject: Warning: View created with compilation errors.
Posted by:  mario…@invera.com
Date: 29 Jan 2004

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
mario…@invera.com

Replies