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-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !

Received Response
56
Views
3
Comments

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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