Hi,

I have created a VIEW (say MY_METER) to retrieve data from various tables. Now I also have created same VIEW name (MY_METER with same structure) to all the domains so I can use a combine sql query statement like:

select * from domain1.MY_METER union all

select * from domain2.MY_METER etc and so on until the very last domain name

Now * can be replaced with any column name I specify in my create VIEW statement. My wish now is how can I create a VIEW say ALL_MY_METER in the system level with the same structure as MY_METER. Anyone can help me here?

Hi Ilan,

I use the sql below.

GRANT SELECT ANY TABLE to IN_DBAMN;