Re: Resizing datafiles

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Thu, 20 Jul 2000 3:59 -0500
Message-Id: <10564.112509@fatcity.com>

Hi,

Resizing of a datafiles (reducing the size) would normally be done when you discover that the size is way too high 2)You would like to reuse the space now rather than wait ...... (no new disk,cost.....etc factors)

       Before reducing the size Ensure that  the datafile is really
       free.
       For a temp tablespace ....there are no sort activity.......

       ALTER DATABASE
           DATAFILE 'Filename'  RESIZE <new size> M;



                      Hope this helps ...
                                shreepad

Received on Thu Jul 20 2000 - 03:59:00 CDT