need to create a script to generate 300 materialized view tables
Hi, guys,
I need a script to generate around 300 metrialized views. Something like this for one table GN_ACCESS_CODES:
create snapshot GN_ACCESS_CODES on prebuilt table refresh fast for update as select
ID,
ORDER_EVENT_ID,
ACCESS_CODE,
AVAILABLE_COUNT,
ACTIVE,
EXPIRATION
from GN_ACCESS_CODES@datahelios.esri.com;
In this script, I got the table name GN_ACCESS_CODES from dba_repobject table and column_name (ID, ORDER_EVENT_ID,...) from dba_tab_columns table then concatenated together in order to create above script.
Can any one show me the example to do it? I have around 300 Mviews were replicated in system.
Thanks,
Frank
replication materialized views
Yes, I wish I can just create few Mviews instead of 300 but this is all been created in last three years. I just need some do loop example or how to setup all at one time.
Thanks again,