ORA-01652: Unable To Extend Temp when Gathering Statistics with Granularity Not Set to Partition
(Doc ID 1590680.1)
Last updated on JUNE 18, 2021
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- When gathering statistics for an extremely large table (in this example 924G), the following errors are received despite the fact that the temporary tablespace is very large (over 300G).
Changes
none
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 |