ORA-1654, ORA-1653, ORA-1658 When Tablespace has plenty of free space (Doc ID 1539699.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 01-Dec-2016***
No Object in the Recycle bin for this Tablespace :

SQL>select * from dba_recyclebin where ts_name = '';

Symptoms

When using Automatic Segment Space Management (ASSM),
The following error could be reported

ORA-1653: unable to extend table <Segment NAME> by 128 in tablespace <tablespace_name>

 

Where confirmed that plenty of free space as follow :

SQL>select * from dba_free_space where where tablespace_name = '<TSNAME>' and
blocks >= 128;

Reported so many rows , so lot of space available with size > 1MB

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms