Error ORA-30036
Descripción:
ORA-30036: no se ha podido ampliar el segmento en en el tablespace de deshacer '' (unable to extend segment by string in undo tablespace 'string')Causa:
las tablas se especifica deshacer no tiene más espacio disponible. Traducción automática de: the specified undo tablespace has no more space available.Acción:
Añadir más espacio a las tablas deshacer antes de volver a la operación. Una alternativa es esperar hasta que las operaciones activas de cometer. Traducción automática de: 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 | 7/21/2006 2:44:56 PM
RE: ORA-30036
como soluciono el error
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
por Fernando VAlenzuela | 7/27/2007 6:26:45 PM
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
Plugin buscador de errores