Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-01652 on Shared ATP - is there an upper limit on TEMP tablespace allocation?

edited Apr 16, 2022 7:54AM in Autonomous Database 2 comments

Summary

Curious what the upper limit is (if known)

Content

Update - will move to an internal forum - my apologies. We are technically a cloud customer (albeit internal) and was not getting answers elsewhere. I've since been pointed to a more appropriate location. Question was a generic one about temp tablespace allocation.

 

Version

19C ATP on OCI Shared Infrastructure

Code Snippet

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP (temp segment was showing about 315gb used when this occurred - for ref, this has been solved).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!