Dynamically update VIEW object without alter command
Hi,
Is it possible by adding entry of database name to a .CSV file, a view will somehow take into account the new entry (new database) if it exists?
perhaps I can make new CSV file and every time I update the csv file I could get the views to somehow automatically include new database entry (orcl3)
list.csv
orcl1
orcl2
orcl3
In affect the view would some how automatically update from
create view v1 as
select * from t1@orcl1
union select * from t1@orcl2
update to:
create view v1 as
select * from t1@orcl1
union select * from t1@orcl2