Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Accessing Table from Multiple databases

Basavaraj - OracleMar 5 2014 — edited Mar 16 2014

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 8 2014
Added on Mar 5 2014
3 comments
1,296 views