Use ALTER DATABASE DATAFILE <FILE_ID> RESIZE <N>K/M COMMAND


----- Original Message -----
From: "dgaikwad" <oracledba-ezmlmshield-x52422684.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, July 31, 2007 12:06 PM
Subject: Resize UNDOTBS01.DBF


> Hi DBA's
>
> I want to reduce the size of the
>
> UNDOTBS01.DBF file
>
> it takes lots of size.
>
> is it possible to reduce the size of this file?
>
> Thanks & Regards,
> Dinesh G.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>

Oracle LazyDBA home page