Materialized view log for selected rows

[sam93]

Hi,

Is it possible to create a materialized view log on a table for some rows only. I have a huge table (about 25 mil. rows) with STATUS column. About 5% of the rows have a TYPE_CODE of '04'. Is it possible to create mat. view log only to track changes in those rows.

If this is not possible then what can be a more efficient solution to meet this requirement? I cannot make any changes in the source table, such as creating a database trigger or moving these rows to another table.

Thanks.

 

[sem]

Why do you need MV? Creating bitmap index may solve your problems. In any case you obviously may add where clause to your MV.

Regards, Dima

http://seminihin.narod.ru

 

[sam93]

Hi,

I cannot make any changes to the source table, including creating an index. I think I'll have to filter it in the mat. view with the WHERE clause.

Thanks for your help.