Materialized views with rowid question

From: Mike Hayes <funrx1_at_gmail.com>
Date: Mon, 11 Mar 2013 16:47:43 -0400
Message-ID: <CAJOXhwRcwU9M9PF8h6EVcLaiNj-YTDrOVkeTH_xxqFe-M3Jjjw_at_mail.gmail.com>

If I create a materialized view log 'WITH ROWID' on a table that has row movement enabled and later do alter table shrink or flashback table is the materialized view log kept up to date?
For example:

CREATE MATERIALIZED VIEW LOG ON T NOCACHE WITH ROWID INCLUDING NEW VALUES; Later I issue:

alter table T shrink space compact;

I have always used a primary key when working with rowid in the past but unfortunately vendor product whose table does not have a primary key. Should I make sure the row movement is disabled on tables with MVs created like this?

Thanks in advance - Mike

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 11 2013 - 21:47:43 CET