Kbase 50096: Erro ORA-01654
| Autor |
Marco Aurelio Scheidt - CAT |
| Acesso |
Público |
| Publicação |
19/11/2014 |
|
Ambiente: Oracle 11gR2, ECM
Erro:
013-10-25 14:33:31,799 INFO [STDOUT] WARN JDBCExceptionReporter - SQL Error: 1654, SQLState: 72000
2013-10-25 14:33:31,799 INFO [STDOUT] ERROR JDBCExceptionReporter - ORA-01654: unable to extend index ECM.FORMINDEX by 512 in tablespace TB_ECM
2013-10-25 14:33:31,799 INFO [STDOUT] WARN JDBCExceptionReporter - SQL Error: 1654, SQLState: 72000
2013-10-25 14:33:31,799 INFO [STDOUT] ERROR JDBCExceptionReporter - ORA-01654: unable to extend index ECM.FORMINDEX by 512 in tablespace TB_ECM
Causa:
ORA-01654: unable to extend index string.string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Solução:
Solicitar para o DBA da empresa aumentar o espaço da tablespace ou incluir um outro DATAFILE para a tablespace.