Re: Resize Datafile

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Thu, 07 Feb 2002 21:47:05 GMT
Message-ID: <3c62f54e.484181@news.freeler.nl>

If you want to know to which size you can shrink your datafile:

select max(block_id+blocks -1)
from dba_extents
where file_id = <file_id of the datafile>

This is in blocks, multiply by blocksize (in bytes) to get this in bytes.

Jaap.

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
Received on Thu Feb 07 2002 - 15:47:05 CST