Re: resizing initial extent downwards

Hi Steve

You can do the following:

1. Export the table
2. Drop the table
3. Create the table (use your preferred initial)
4. Import the table using ignore=y

Hth,
Ivan Bajon, ocp

"Steve Salvemini" <steve.salvemini_at_adelaide.edu.au> wrote in message news:3A2353B4.E11B7FDA_at_adelaide.edu.au...
> What we'd like to do is delete 90% of a table (where the initial extent
> has been extended to take up the whole table ie. 250Mb), and reclaim
> that space.
>
> We initially thought that by exporting the table and re-importing it,
> the initial
> extent would be set to the actual size of the table. It doesn't though,
> it keeps it at 250Mb, where the data now only needs 20Mb as an initial
> extent.
>
> We are doing this same process for some 200+ tables so a generic
> solution would be best.
>
> Any ideas?
>
>
> Thanks
>
> Steve
Received on Tue Nov 28 2000 - 04:31:43 CST