Database Administration (MOSC)

MOSC Banner

creating an index with many extents

edited Apr 16, 2009 8:57PM in Database Administration (MOSC) 2 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center