ORA-01653: Unable to extend table %s.%s by %s in tablespace %s The tablespace the table is residing in is unable to extent.
There is not enough space left either due to the datafiles being full, autoextend which is not set at datafile level or due to a disk which's full.
You'll have to check the size of the datafiles attached to the tablespace and check whether they can autoextend or not..
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='TABLESPACE_NAME'
Either add more datafiles to the tablespace, set the autoextensible flag or enlarge the datafile(s).
To add more space to a file issue following command:
alter database datafile 'C:\ORACLE\ORADATA\TOOLS01.DBF' resize 1000m;
To turn on the autoextend feature on a datafile use following command:
alter database datafile 'C:\ORACLE\ORADATA\TOOLS01.DBF' autoextend on next 100m maxsize 2000m;
To add a new datafile to the tablespace use following command:
alter tablespace TOOLS add datafile 'C:\ORACLE\ORADATA\TOOLS02.DBF' autoextend on next 100m maxsize 2000m;
 Forum Messages
| what should i do when get unable to extend undo tablesspace error |
| : -> 07-FEB-2008 03:51:07 | Extend the tablespace | DbMotive | Reply |
You either extend the tablespace or add a datafile to the tablespace.
Check the examples above on how to do that.
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='UNDOTBS1'
|
| :: -> 30-MAY-2008 06:34:33 | Same problem occured , but have enough size in tablespace | M V Sreedhar | Reply |
| I also have the same problem, but i am afraid that concerned tablespace is having enough free space , so what could be the problem? |
| ::: -> 30-MAY-2008 08:50:04 | Can it be a temporary segment | DbMotive | Reply |
What exactly was the error message?
It can be a temporary segment in the tablespace (eg. during index creation), of the TEMP tablespace which is full.
|
Add your message for ORA-01653
|
Home