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.
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