Oracle – ORA-01653 – unable to extend table in tablespace – Fix

Error: ORA-01653: unable to extend table in tablespace Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated. Note: Change the table space name for that you need the information in the below Scripts (Script: 1 & 2) Solution: Script: 1 Execute the below query to find the Used Size, Free Size, Total Size of a table space select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace – tu.totalusedspace) "Free MB", df.totalspace

» Read more