vafanassiev_at_aapt.com.au wrote:
> In Oracle 8i/9i/9.2/10g - how to resize a tempfile if
> a sort segment has grown too big?
> If I try to use
>
> alter database tempfile '/u01/oradata/PROD/temp01.dbf' resize 1000m;
>
> it produces ORA-03297: file contains used data beyond requested RESIZE
> value
>
> So is the any way to drop/resize/"re-initialize" sort segment?
>
> Thanks
>
tempfiles are tempfiles... just create a new one,
and drop the old one.
Assign the new file to the correct tablespace, and that
to the users
--
Regards,
Frank van Bortel
Received on Mon Mar 07 2005 - 03:37:11 CST
