Thursday, February 21, 2008

ORA: 01653: Unable to extend Table

An oracle error when Oracle is unable to extend the table in a tablespace.

Solution:
Extend the tablespace size

alter database datafile 'xyz.dbf' resize 1000M (The new total size)

Getting the datafile: Go to DBA->Segment management and Tablespaces in TOAD.

Sometimes the system may not have enough space for increasing tablespace file size.

Create a new file and attach it to the tablespace

ALTER TABLESPACE
ADD DATAFILE 'abc.dbf' SIZE 100M
AUTOEXTEND ON
NEXT 1024K
MAXSIZE 250M

No comments: