-
Junior Member
Materialized views
I got a materialized view which is based on a table having 100million records.If i added 10 more records to that base table how can i refresh only the newly added 10 records into the Materialized views without using refresh on commit since refresh on commit scans the entire table
-
Re: Materialized views
You need to use fast refresh method.
FAST:-It uses MATERIALIZED VIEW LOG to send changes from master table row to the MAT-VIEW.
and for this u need to create a materialized view log on the source table.
-
Junior Member
Re: Materialized views
In any case u will have to perform the full refresh for reflecting those record. Moreover you can use the fast refresh.;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules