Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shrink tablespace DBFS_DATA on Always Free Autonomous Database

Haytham-aAug 6 2025

After I ran my dbms_datapump job to export my database, the job failed with the below error message:

ORA-19502: write error on file "/u03/dbfs/1A6C0A491A602B76E063175B000A0744/data/dpdump/EXPDAT30-202508040243.DMP", block number 84478 (block size=4096)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device

When I investigated my database disk usage, I found it exceeded the 20GB limit for Always Free Database, although my actual user data was less than few MBs. 15GB were consumed by a tablespace called DBFS_DATA and 4GB used by SYSAUX tablespace.

What are my options to clean up these tablespaces and reclaim some of that space? I don't have access to SYS, and I am on Always Free account, so I don't have any support.

Comments
Post Details
Added on Aug 6 2025
4 comments
157 views