Database Administration (MOSC)

MOSC Banner

Dynamically update VIEW object without alter command

edited Dec 22, 2016 10:50PM in Database Administration (MOSC) 7 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center