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.