Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
This issue is fixed in
There is a concurrency issue with deferred segment creation and INTERVAL partitioning which can lead to errors. This issue may also cause inconsistency between the table an index causing errors like: ORA-8102 ORA-600 [kdsgrp1] ORA-600 [qertbFetchByRowID] ORA-1499 by "analyze table <name> validate structure cascade" Rediscovery Notes: ORA-1502 in tables with deferred segment creation is the most common symptom. Index / Table inconsistency causing several errors. Workaround Force segments to be created - This is a two step process: - Disable deferred segment creation for future objects using the parameter deferred_segment_creation = FALSE - Materialize segments for objects that are currently deferred. This can be done using the DBMS_SPACE_ADMIN.MATERIALIZE_DEFERRED_SEGMENTS() procedure. This segment materialization may be targeted to a particular table partition, table, schema or the entire database depending on the arguments supplied. In all cases, associated dependent objects (lobs/indexes) will be materialized as well.