ORA-30036

Error: ORA-30036: unable to extend segment by string in undo tablespace 'string'

Causa: the specified undo tablespace has no more space available.

Acción: Add more space to the undo tablespace before retrying the operation. An alternative is to wait until active transactions to commit.


Deja tu comentario:

¿No sabes cómo solucionar el error? ¿O lo has conseguido resolver y quieres ayudar a otros usuarios?

Para comentar, haz login con tu cuenta de


COMENTARIOS:

por Anónimo | 21/07/2006 14:44:56

RE: ORA-30036

como soluciono el error
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

por Fernando VAlenzuela | 27/07/2007 18:26:45

RE: ORA-30036

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:ORACLEORADATAUNDO01.DBF' resize 1000m;
To turn on the autoextend feature on a datafile use following command:
alter database datafile 'C:ORACLEORADATAUNDO01.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:ORACLEORADATAUNDOTBS02.DBF' autoextend on next 100m maxsize 2000m;
Was this explanation useful? Want to comment on this error code? We value your feedback
PD : EN FIN AGREGAS MAS ESPACIO A TU UNDO_TABLESPACE.
--
Regards. Saludos.
Luis F. Valenzuela
Phone: +56 9 82002848
Oracle Consultant
fdo.valenzuela@gmail.com

por emardila | 03/11/2011 02:43:59

RE: ORA-30036

Me ayudó mucho en la solucion de este error reportado en una base de datos oracle 11g