ORA-30036: Unable to extend segment by %s in undo tablespace '%s' The undo tablespace you are currently using 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 undo tablespace and check whether they can autoextend or not..
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='here UNDO TABLESPACE_NAME'
Either add more datafiles to the undo 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\UNDO01.DBF' resize 1000m;
To turn on the autoextend feature on a datafile use following command:
alter database datafile 'C:\ORACLE\ORADATA\UNDO01.DBF' autoextend on next 100m maxsize 2000m;
To add a new datafile to the undo tablespace use following command:
alter tablespace UNDOTBS01 add datafile 'C:\ORACLE\ORADATA\UNDOTBS02.DBF' autoextend on next 100m maxsize 2000m;
 Forum Messages
Hi,
We are facing problem while running a process called as "MOVE TO HISTORY".This process tranfers data from standard table to history table in bulk.
When the first time this process is executed it is giving error "Unable to extend segment by8 in UNDO tablespace 'UNDOTBS1'"
After this we increased the UNDO tablespace to 2GB and try to execute the process again bt again we got the same error.
Then we again increased the space and now it is 5GB and also now there is no maxbytes, no autoextensible but now again we are getting the same error.
Cau you please tell why we are getting this error and is there is any other way to solve this problem
Kind Regards,
Tannu Sahay
|
| : -> 01-APR-2008 15:26:48 | It depends | DbMotive | Reply |
It all depends on the volume of data you are trying to move, and what happens behind the screen.
A move operation can generate a lot of UNDO information, specially if the tables contain triggers which insert some audit info into other tables, if there are a lot of depending (child) tables involved, ...
It's difficult to tell how much UNDO the move operation needs.
What you can do is to monitor the transaction in v$transaction for the session the move operation is taking place, and interpolate the space needed for the amount of records that are being moved.
|
Add your message for ORA-30036
|
Home