Re: Creating Views joining tables in two different schemas

What errors?

 If error messages are security related - try GRANT SELECT to other  schema table directly to view owner ( not through role ).

 HTH. Michael.

In article <FoBAOd9iUxA+6a=93q7Z3vSZVd5z_at_4ax.com>,   Ed Ziegler <eziegler_at_nextphase.com> wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 09 2000 - 00:00:00 CDT