title: Cannot enter data into an Oracle table in production through stored procedure
body: <p>The row count of the table is 671839. The sequence is in order. Transactions have been made to the table yesterday like it had been made on for the last 7 months, i.e. since the last application deployment. Nothing has been changed in the application code or database in the last 7 months and everything was working fine. Suddenly after some successful transactions, insertions have been failing to the table since middle of yesterday! No error messages in browser.
  I have exported the whole database, but cannot import the concerned table using oracle import script in cmd prompt.
  The following error is shown:</p>
  
  <blockquote>
    <p>IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate
    MINEXTENTS beyond 8 in tablespace USERS</p>
  </blockquote>
  
  <p>Here is the <code>DDL</code> for the table:</p>
  
  <pre><code>CREATE TABLE MDP.TBL_DAILY_DATA
  (
    DAILY_DATA_ID        NUMBER(38),
    METER_ID             NUMBER(38),
    D_DATE               DATE,
    FREQUENCY_POWER_SUM  FLOAT(126),
    WH_REG_VALUE         FLOAT(126),
    VAR_REG_HIGH_VALUE   FLOAT(126),
    VAR_REG_LOW_VALUE    FLOAT(126),
    RECEIVED_DATE        DATE,
    DETAIL               SYS.XMLTYPE,
    DETAIL_TEXT          VARCHAR2(4000 BYTE),
    MWH_DETAIL               SYS.XMLTYPE,
    MWH_DETAIL_TEXT          VARCHAR2(4000 BYTE)
  )
  XMLTYPE DETAIL STORE AS CLOB (
    TABLESPACE USERS
    ENABLE       STORAGE IN ROW
    CHUNK       8192
    RETENTION
    NOCACHE
    LOGGING
    INDEX       (
          TABLESPACE USERS
          STORAGE    (
                      INITIAL          64K
                      NEXT             1M
                      MINEXTENTS       1
                      MAXEXTENTS       UNLIMITED
                      PCTINCREASE      0
                      BUFFER_POOL      DEFAULT
                     ))
        STORAGE    (
                    INITIAL          64K
                    NEXT             1M
                    MINEXTENTS       1
                    MAXEXTENTS       UNLIMITED
                    PCTINCREASE      0
                    BUFFER_POOL      DEFAULT
                   ))
  TABLESPACE USERS
  PCTUSED    0
  PCTFREE    10
  INITRANS   1
  MAXTRANS   255
  STORAGE    (
              INITIAL          272M
              NEXT             1M
              MINEXTENTS       1
              MAXEXTENTS       UNLIMITED
              PCTINCREASE      0
              BUFFER_POOL      DEFAULT
             )
  LOGGING 
  NOCOMPRESS 
  NOCACHE
  NOPARALLEL
  MONITORING;
  
  
  CREATE UNIQUE INDEX MDP.UK_TBL_DAILY_DATA ON MDP.TBL_DAILY_DATA
  (METER_ID, D_DATE)
  LOGGING
  TABLESPACE USERS
  PCTFREE    10
  INITRANS   2
  MAXTRANS   255
  STORAGE    (
              INITIAL          3M
              NEXT             1M
              MINEXTENTS       1
              MAXEXTENTS       UNLIMITED
              PCTINCREASE      0
              BUFFER_POOL      DEFAULT
             )
  NOPARALLEL;
  
  
  ALTER TABLE MDP.TBL_DAILY_DATA ADD (
    PRIMARY KEY
    (DAILY_DATA_ID)
    USING INDEX
      TABLESPACE USERS
      PCTFREE    10
      INITRANS   2
      MAXTRANS   255
      STORAGE    (
                  INITIAL          1M
                  NEXT             1M
                  MINEXTENTS       1
                  MAXEXTENTS       UNLIMITED
                  PCTINCREASE      0
                 ),
    CONSTRAINT UK_TBL_DAILY_DATA
    UNIQUE (METER_ID, D_DATE)
    USING INDEX MDP.UK_TBL_DAILY_DATA);
  </code></pre>