1 Reply Latest reply: Apr 26, 2013 1:27 AM by Piyush Chauhan RSS

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

    Lucas Andres Muñoz
      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.