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
"Edwinah63" <edwinah_at_customercare.com.au> wrote in message
news:1138929795.512719.61940_at_g47g2000cwa.googlegroups.com...
>
> 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
>
You will get an error if you try to shrink it too small. It won't hurt
anything, but the shrink will not happen.
Jim
Received on Thu Feb 02 2006 - 21:19:47 CST