ORA-01659: unable to allocate MINEXTENTS . . . creating a INDEX

From: jose luis fernandez diaz <jose_luis_fdez_diaz_news_at_yahoo.es>
Date: 9 Jul 2004 08:06:06 -0700
Message-ID: <c2f95fd0.0407090706.44cc6be6@posting.google.com>

I have a lot of space in data files binds to tablespace "CUSTOM_TBS_ARTICULOS_IX_01", but it seems that Oracle doesn't see it. What is the problem ?

CREATE INDEX ARTICULOS_PED_IX ON CUST_PDD_ARTICULOS (ID_PEDIDO)
  INITRANS 2
  MAXTRANS 255
  STORAGE (

              INITIAL          512K 
              NEXT             512K 
              MINEXTENTS       20 
              MAXEXTENTS       256 
             )

NOLOGGING
LOCAL STORE IN (CUSTOM_TBS_ARTICULOS_IX_01) NOPARALLEL; ORA-01659: unable to allocate MINEXTENTS beyond 18 in tablespace CUSTOM_TBS_ARTICULOS_IX_01 SQL> select * from dba_data_files where
TABLESPACE_NAME='CUSTOM_TBS_ARTICULOS_IX_01'; FILE_NAME

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS

RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY

------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- ------------

USER_BYTES USER_BLOCKS
---------- -----------
/detection_fms80/DB/custom_tbs_articulos_ix_01.dbf

        51 CUSTOM_TBS_ARTICULOS_IX_01        8388608       1024
AVAILABLE           51 NO           0          0            0

   8380416        1023 



/detection_fms80/DB/custom_tbs_articulos_ix_03.dbf 

        63 CUSTOM_TBS_ARTICULOS_IX_01     1073741824     131072
AVAILABLE           63 NO           0          0            0

1073733632      131071

FILE_NAME

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS

RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY

------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- ------------

USER_BYTES USER_BLOCKS
---------- -----------

/detection_fms80/DB/custom_tbs_articulos_ix_04.dbf

        64 CUSTOM_TBS_ARTICULOS_IX_01       20971520       2560
AVAILABLE           64 NO           0          0            0

  20963328        2559 



/detection_fms80/DB/custom_tbs_articulos_ix_05.dbf 

        65 CUSTOM_TBS_ARTICULOS_IX_01       20971520       2560
AVAILABLE           65 NO           0          0            0

FILE_NAME

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS

RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY

------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- ------------

USER_BYTES USER_BLOCKS
---------- -----------
20963328 2559

SQL> select * from user_tablespaces where tablespace_name='CUSTOM_TBS_ARTICULOS_IX_01'

TABLESPACE_NAME                INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS

-------------- ----------- ----------- ----------- ------------ ---------- --------- ---------

LOGGING EXTENT_MAN ALLOCATIO
--------- ---------- ---------

CUSTOM_TBS_ARTICULOS_IX_01              40960       40960           1 
       505           50          0 ONLINE    PERMANENT

LOGGING DICTIONARY USER Received on Fri Jul 09 2004 - 10:06:06 CDT