Unrecoverable Changes reported in v$datafile for User tablespace datafiles due to Internal Compression Advisor tables
Last updated on FEBRUARY 16, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
Application related tablespace all have Logging attributes set at segment level.
Database doesnot have Force logging mode enabled, However there are No nologging operations like Append with Parallel hint,Direct load are done through Application.
V$datafile shows Unrecoverable_change# and Unrecoverable_time for user tablespace datafiles.
Object involved has a name starting with CMP example :- CMP4$225 etc
Where the last two digits indicates the Object id of the for which this compression table was created
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 hundreds of Community platforms