ORA-01653 unable to extend table in tablespace
Issue/Symptom/Question
The following error can reference any table. These are just two examples.
ORA-01653: unable to extend table PENTA.LAB_TRAN by 8192 in tablespace PENTA
ORA-01653: unable to extend table PENTA.PR_CHK_FRNG_HIST_PK by 8192 in tablespace PENTA
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Applies To
PENTA for Windows
Any database
Any table
Any tablespace name but most likely it will be PENTA tablespace
Resolution/Fix/Answer
An Oracle Database Administrator needs to add datafiles to the database tablespace in question.
- Contact your company Internal IT, if they are the Oracle Database Administrator, or
- Please log a Service Desk Ticket with Penta and reference this article, if Penta provides Hosting or Oracle Database Administration
If you are an Oracle DBA see: Adding a Database file