Skip to Main Content
Forums

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!

union for all 100x1 row view.

846231May 29 2012 — edited May 30 2012
Hi all,

I have 100 oracle database of different versions.

I have a central monitoring server which has db links to all the 100 database.

For each database I have a single row table which has column db_name and latest patch level. This patch leve gets updated often.


So in my central monitoring db, I create 100 views for all this single row table.


My question is how can I create a view that is union to all this 100 single-row-table?

Does union has no limit to unite 100 tables?


Thanks a lot,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2012
Added on May 29 2012
#general-database-discussions
10 comments
151 views