ORA-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !
Hi,
The current situation on my Always Free tenant/Autonomous Transaction Processing DB: jofodb/jofodb1:
SQL> select round(sum(bytes/1024/1024/1024),2) Size_gb from dba_data_files where tablespace_name != 'SAMPLESCHEMA';
SIZE_GB
--------
28.43
SQL> select round(bytes/1024/1024/1024,2) Size_gb, tablespace_name from dba_data_files order by 1 desc;
SIZE_GB TABLESPACE_NAME
-------- ------------------------------
200.00 SAMPLESCHEMA
16.11 DATA
9.53 SYSAUX
1.59 SYSTEM
1.00 UNDO_29
.10 DBFS_DATA
.09 UNDO_31
therefore in cannot acces apex develpment environment and runtime.
... facing HTTP ... internal server error 5000
reason (probably):
ORA-65114: Speicherplatznutzung im Container ist zu hoch
i still can connect via SQL Developer and can execute simple sqls
but getting error when more space is needed: