Re: Materialized views with rowid question
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "funrx1@xxxxxxxxx" <funrx1@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Mar 2013 14:55:08 -0700 (PDT)
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: