Hello :

I am creating a table with 20 partitions to store data and approx size of the table is about 20GB worth of data. One of the TS definition and table storage clause is listed below.

create tablespace y02p01 datafile '/u01/dbs/OD/y02p01a.dbf' size 500M
autoextend on next 100M extent management local uniform size 100M;

Create table xyz (columns) and with
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE (initial 10M next 10M pctincrease 0 maxextents unlimited);

In that tablespace y02p01 only one table partition will exist.

How will my extents be, when I start pumping in data?

Thanks, ST2000