creating an index with many extents
I created a tablespace with these parameters
CREATE SMALLFILE TABLESPACE "tablespacename" DATAFILE 'datafilename' SIZE 256M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
The tablespace was created with 64K (default value) Initial Extent. I created two indexes over this tablespaces with a size initial extent of 40M, these indexes don't have data, but when I created indexes, one index was created with 40 extents and the other index was created with 1 extent, Why an index was assigned 40 extens if the table is empty.
CREATE SMALLFILE TABLESPACE "tablespacename" DATAFILE 'datafilename' SIZE 256M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
The tablespace was created with 64K (default value) Initial Extent. I created two indexes over this tablespaces with a size initial extent of 40M, these indexes don't have data, but when I created indexes, one index was created with 40 extents and the other index was created with 1 extent, Why an index was assigned 40 extens if the table is empty.
0