ORA-01653: unable to extend table INDO.TB_COP_OBJ by 128 in tablespace USER ORA-06512: at line 4

General
1

Getting below error at database level:

ORA-01653: unable to extend table INDO.TB_COP_OBJ by 128 in tablespace USER
ORA-06512: at line 4

How we can resolve this?

4 Likes
2

@VivekBhardwaj Could you please answer?

1 Like
3

ORA-01653 means your table space is running short of storage.

You may add a new datafile to the table space and it should be OK.

Just add a new datafile for the existing tablespace

ALTER TABLESPACE LEGAL_DATA ADD DATAFILE '/path/to/new.dbf' SIZE XXXM;

To find out the location and size of your data files:

SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'YOUR_TABLESPACE_NAME_HERE';

Refer below official documentation for tablespace to auto-extend:
https://docs.oracle.com/cd/E18283_01/server.112/e17120/dfiles003.htm

6 Likes