Re: no rows returned on execution

As you rightly pointed out, the view uses USER_TAB_COLUMNS of user y. Try using ALL_TAB_COLUMNS where owner = 'X' in the view. This will force the view to retrieve data from SCHEMA 'x'.

I believe you should have access to ALL_TAB_COLUMNS. It is same as in structure as USER_TAB_COLUMNS, you have a additional column OWNER. The OWNER is the user who owns that object.

Hope it helps.

Regards

N.Prabhakar
Socgen Crosby Securities
Singapore Received on Fri Nov 08 1996 - 00:00:00 CST