Hi Team,
We have a situtation where we need to access the same table across 5 database - each have one common schema with union output.
Example :
Database are and schema is as below,
DB1 - > DBS1 Schema -> EMP Table
DB2 -> DBS2 Scehma -> EMP Table
DB3 -> DBS3 Schema -> EMP Table
DB4 -> DBS4 Schema -> EMP Table
DB5 -> DBS5 Schema -> EMP Table
Output requested on Seperate DB.
select * from emp@DBS1@DB1
union
select * from emp@DBS2@DB2
union
select * from emp@DBS3@DB3
union
select * from emp@DBS4@DB4
union
select * from emp@DBS5@DB5
CAN YOU PLEASE SUGGEST WHICH WILL BE THE BEST WAY TO ACHIVE THIS. Materilized View or normal VIEW or is there any other metod to achive this.
Regards,
Basavaraj M