This discussion is archived
1 Reply Latest reply: Apr 25, 2013 11:27 PM by 1005661 RSS

ORA-01658: unable to create INITIAL extent for segment in tablespace LARGE_

Lucas Andres Muñoz Newbie
Currently Being Moderated
Hello, I'm having problems when I'm trying to create a order, I'm having the next response:
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header/>
<env:Body>
<env:Fault xmlns:ord="http://xmlns.oracle.com/communications/ordermanagement">
<faultcode>ord:fault</faultcode>
<faultstring>Caused by java.lang.RuntimeException: com.mslv.oms.handler.InternalErrorException: ORA-01658: unable to create INITIAL extent for segment in tablespace LARGE_INDEX
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
: ORA-01658: unable to create INITIAL extent for segment in tablespace LARGE_INDEX
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
</faultstring>
<faultactor>unknown</faultactor>
<detail>
<InvalidOrderSpecificationFault xmlns="http://xmlns.oracle.com/communications/ordermanagement">
<Description>Caused by java.lang.RuntimeException: com.mslv.oms.handler.InternalErrorException: ORA-01658: unable to create INITIAL extent for segment in tablespace LARGE_INDEX
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
: ORA-01658: unable to create INITIAL extent for segment in tablespace LARGE_INDEX
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
</Description>
</InvalidOrderSpecificationFault>
</detail>
</env:Fault>
</env:Body>

Any body knows how to fix this problem permanetly?, becouse I already add some space to the data file with the next sentence:
ALTER TABLESPACE large_index ADD DATAFILE '/opt/oracle/data/large_index02.dbf' SIZE 1600M;

This created the new file and make it works correctly but 1 hour after that, I get the same error.

Thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points