Re: Materialized views with rowid question

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 11 Mar 2013 14:55:08 -0700 (PDT)
Message-ID: <1363038908.84225.YahooMailNeo_at_web121605.mail.ne1.yahoo.com>

SQL> alter table emp shrink space;
alter table emp shrink space
*
ERROR at line 1:
ORA-10663: Object has rowid based materialized views SQL> David Fitzjarrell

---

From: Mike Hayes <funrx1_at_gmail.com>
To: oracle-l_at_freelists.org
Sent: Monday, March 11, 2013 2:47 PM
Subject: Materialized views with rowid question

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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 11 2013 - 22:55:08 CET