Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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