Re: resizing initial extent downwards
Date: Tue, 28 Nov 2000 11:31:43 +0100
Message-ID: <9001if$j59$1_at_news.inet.tele.dk>
Hi Steve
You can do the following:
- Export the table
- Drop the table
- Create the table (use your preferred initial)
- 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 - 11:31:43 CET