Re: Is it possible to reduce the datafile size?

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.

>