Re: [Q] Can you shrink tablespaces?

"Przemysław Pakulski" <przemop_at_talex.com.pl> wrote:

>
>Chris Muir napisał(a) w wiadomości: <35d27df8.155785938_at_mitswa>...
>>Howdy.
>>
>>I currently have a tablespace that is 30% percent full. The data in
>>the tablespace is static and wont change or grow. Is there a way to
>>shrink the tablespace size to obtain the disk space back?
>>
>You can try following:
>
>ALTER TABLESPACE tablespace DATAFILE datafile RESIZE xxM
>
>where xx is the new size of datafile in MB.
>
>Przemo Pakulski
>przemop_at_talex.com.pl
>
>
>

The above will not work...

Here it is:

alter database datafile 'path and file_name' resize SIZEM;

Robert Prendin

#****************************************************
#	RP Data Solutions Inc.
#	Specializing in ORACLE DBA Support Services
#       We offer 24HR remote DBA support!!!
#****************************************************