URGENT: Err Code 1653 Unable to extend table in tablespace I am running a PL SQL procedure which will be called through a unix script. This procedure will run some update statements on several tables. I am getting an error code -1653. The table I am trying to update has 65000 rows. I am able to successfully update 3 of its columns. On attempting to update the fourth column the error occurs. Apart from this column one more column has to be updated(Total 5 columns). The exact error message is 'unable to extend table ABCD.EFGH by 30 in tablespace XYZ' I ran the following query. Code (SQL): select max(bytes/1024/1024) max_Mega from dba_free_space fs where fs.tablespace_name='XYZ' Code (SQL): and got the result as MAX_MEGA = 0.1171875 1653 I suppose is something related to table extents. 1. Can someone tell me how can I increase the table extent. I think this can be increased by ALTER TABLESPACE or by using ORACLE ENTERPRISE MANAGER. Can anyone explain the exact procedure for both? 2. Can there be any problem if I increase extent size to UNLIMITED? What is autoextent? 3. How is extent size exceeded when UPDATE statement is run? 4. Will I need the extra space allocated for table extent after COMMIT, considering that the original table has been existing and functioning quite fine for sometime.