Hi Experts,

I have two schema in one database and all the tables are same in both schema with different data.I need to create another schema in which the all the tables have to be same but i need to view data from the other two schema that is in the third schema the tables should contain data from both the schema together.How can i achieve this?

Please help me.

Thanks in Advance.

You can create VIEWs with UNION ALL for third schema, like this:

CREATE VIEW third_schema.table_x AS
SELECT * FROM first_schema.table_x
UNION ALL
SELECT * FROM second_schema.table_x

Thanks Tonkuma