Re: Command to free unused space in a data file

Hi Noons,

many thanks for this reply. if i use the command you gave:

> alter database datafile 'filepathname '
> resize <whatever-you-want>M;
>
> "M" is for MB.

do I risk sizing the datafile below the minimum amount necessary for my tablespace and losing my data?

if so, where can I check what the minimum for a particular tablespace should be before I merrily resize my datafiles - since I'm only interested in freeing unused blocks back to the os.

Otherwise, does Oracle throw and error if I try to make the datafiles too small?

Regards

Edwinah63 Received on Thu Feb 02 2006 - 19:23:15 CST