Re: Resize Datafile

On 7 Feb 2002 06:25:46 -0800, poitrasg_at_crcsogema.com (Gaetan Poitras) wrote:

>Hello.
>I am looking to find a solution to reduce the size of a datafile. Is
>it possible and how..?
>Thank you

Hi,

Alter database datafile 'bla-bla_01.dbf' resize <n> K|M;

This way you can both increase and decrease the size of the datafile.

Beware that you can only decrease the size of the datafile with the space that is free between highest used block of the datafile and the last block of the file. If the tablespace is fragmented, the free spaces between extents cannot be deallocated this way. Check dba_free_space for details.

Regards,

• Kenneth Koenraadt