View does not return any data
471240May 20 2009 — edited May 20 2009All,
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