Warning: View created with compilation errors.

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 Received on Thu Jan 29 2004 - 14:36:38 CST