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

Need to shrink tablespaces after datapump: ORA-65114 (Always Free APEX)

in Autonomous Database 2 comments

Summary:

I have basically the same issue as this other thread:


I created schemas with my tables and data from datapump exports (using object storage and dbms_cloud). A total of 10 schemas were imported this way - one at a time. My datapump file was ~4GB. This process has left me with a very large DBFS_DATA tablespace (due to importing into the DATA_PUMP_DIR when loading a datapump file from object storage).


There appears to be no way to shrink my database.


Shortly after deployment, I started to receive the "Space Usage in container is too high" error, likely due to SYSAUX growth related to query plans or APEX logging. If I could shrink DBFS_DATA (which is empty) I wouldn't have any issues.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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