DBA_SEGMENT view shows zero bytes incorrectly for Partitions in BIGFILE tablespace
(Doc ID 2773547.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
DBA_SEGMENT view shows zero bytes incorrectly for Partitions in BIGFILE tablespace.
Below query from dba_segments is showing zero bytes incorrectly. Data is present in the partition as confirmed by querying the partition.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |