What have you set UNDO_RETENTION to? Not setting autoextend on the datafile
would seem appropriate as well.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message
news:b41qir$1r8hm4$1_at_ID-114658.news.dfncis.de...
> Hello all,
>
> The size of the UNDOTBS01.DBF tablespace file has
> become incredibly large and I would like to truncate it.
> Can anyone advise whether is possible and how to do that?
>
> I do all developing and testing on my W2K laptop and found
> out that shutting down the server and putting a fake empty temp
> DBF file and deleting the original one works fine :-) so I know
> at least how to get rid of this one...
>
> TIA,
> Best Regards,
> Giovanni
>
>
Received on Tue Mar 04 2003 - 04:08:02 CST
