Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

View does not return any data

471240May 20 2009 — edited May 20 2009
All,

Here is my query.

I have two tables t1 (main table) , t2 ( history table) both with same structure. t1 is the existing table containg some 1000 reocrd. t2 is new table I have created. I have created a view stvw as like bellow in one schema

create or replace view stvw
as
select * from t1
union
select * from t2

I have given grant to another schema (schema2) like

grant all on schema1.t2 to schema2
grant all on schema1.stvw to schema2


synonym as

create or replace synonym schema2.t2 for schema1.t2
create or replace synonym schema2.stvw for schema1.stvw

when i query from schema2 ,
using table t1 -> Data is comming
using table t2 -> No data ( As this is new table )
using view stvw -> No Data

My question is when I use the view, as the table t1 contains the data, view also should return same number of data.

But I am not getting any data. please help me. I am made any mistake pls correct me.

Thanks in advance

Gopi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2009
Added on May 20 2009
5 comments
1,739 views