My Oracle Support Banner

ROW ID Mismatch with Fast Refresh on BIGFILE vs. SMALLFILE ORA-1 (Doc ID 1665434.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


An Application with updates to a PS_Customer table is audited.  The audit information is based on MLOG$ (MV) on the base table.

Previous functionality in 10gR2 was to track the rowid of the Changes made to the base table which would create an update in the MLOG$.

- If there was an update (or delete) shortly after or anytime prior to the fast refresh, you would only find ONE row in the MLOG$ for that particular entry + their table RowID.

Two rows tracked in the MLOG$ when tables created on BIGFILE Tablespace as of 11g Release 2, multiple rows with different rowids are created when doing the update.

This was verified to work as it did in 10gR2 with the table on SMALLFILE tablespace, but fails when the table is on BIGFILE tablespace.

Fast Refresh can fail with ORA-1.


 Moved tables to BIGFILE tablespace when moved the application to 11g.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.