Creating Views joining tables in two different schemas

I've tried to create a view using a query joining tables in the current schema and a different schema. The query statement itself works when run interactively with SQLPlus, but creating the view errors when I try to create the view.

The query is like:

SELECT A.FIRST, B.SOMETHING
FROM LOCAL_TABLE A, OTHER_SCHEMA.TABLE B WHERE A.KEY = B.KEY; The query returns values when run. But when I try to create a view as 'CREATE VIEW foo AS SELECT ...' the statement errors out and the view is not created.

Perhaps I'm trying to do something that isn't permitted in Oracle, but if anyone knows a solution or where I'm going wrong I would appreciate some help.

Thanks,

Ed Received on Fri Jun 09 2000 - 00:00:00 CDT