ORA-1654, ORA-1653, ORA-1658, ORA-1683 When Tablespace has plenty of free space

(Doc ID 1539699.1)

Last updated on MAY 09, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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 = '';


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


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