Have tried issuing the following:

select * from scrpei_rec@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@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

--
================================================== =================

Brian Peasland
dba@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"