Tablespace def and Table def on storage
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?
extents will be 100MB each
this kind of things are proved easily, try it and see and you will learn more than you learn by asking someone else
Click Here to Expand Forum to Full Width