Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Storage Calculation
Hello Gurus
I have a question that how do I calculate the required initial and next extent on a tablespace and a table. The scenario is I have a tablespace which is fragmented a lot and have many data files. This tablespace has many tables with different sizes. Now I want to export the tablespace with compress=y option and want to import them in a big datafiles of 2gig each.
In order to do that I want to have a different set of storage parameters.
I have the query for used extents and available extents on table and fragmentation on tablespoace.
What would be an appropriate calculation ??
Thanks much
MCG