Re: Is it possible to reduce the datafile size?

From: David P <davidp3_at_soho.ios.com>
Date: 1996/06/22
Message-ID: <31cb9efa.3149783_at_198.4.75.200>#1/1


On 21 Jun 1996 16:40:43 GMT, vgoel_at_pts.mot.com (Vikram Goel (Cntr)) wrote:

>Kittu.
>
>There is no direct way in Oracle to reduce the datafile space, but a method
>exists. First export all the objects wich exist in the tablespace. then
>export this out, drop the tablespace, remove the datafile, create the same
>tablespace again with a lower size of the datafile, inport the objects in.
>
>Hope this helps.
>
>--
>Vikram Goel
>Sr. Oracle DBA - Consultant
>Aerotek Inc. My email: vgoel_at_emi.net
>
>Motorola Info: Motorola email: vgoel_at_pts.mot.com
>Mail Stop 39, Room S1014
>1500 Gateway Blvd,
>Boynton Beach, FL 33426
>
>
>In article <DtBon3.AFx_at_news.hawaii.edu>, kittu_at_gis.eng.hawaii.edu (Chakravarthy Nalamotu) writes:
>>Hi Oracle Users,
>>Is it possible to reduce the datafile size
>>with/without losing data. I have a datafile,
>>using 10% of the space. Was wondering if I
>>can rip off some of that un-used space.
>>Atleast, at this point I do not intend to drop the
>>tablespace though.
>>
>>Thank you for your replies,
>> Kittu.
>>
>
>
>
And don't forget to recreate all GRANTS :( Dave Received on Sat Jun 22 1996 - 00:00:00 CEST

Original text of this message