Hi ALL,
When I query DBA_MVIEWS with the following query (
select OWNER, MVIEW_NAME, REWRITE_ENABLED, REWRITE_CAPABILITY from dba_mviews I get the REWRITE_CAPABILITY Column value as:

1) GENERAL
2) NONE
3) TEXTMATCH

Can someone explain what this mean?

Thanks