Hi dinesh,

The syntax alter database ... is correct but it's not always possible to
reduce the size of the undo tablespace using this command.

Other way of reducing size is to create another undo tablespace and make it
the default undo for the database.
The best time to do this is after a restart the db.
After that, remove the earlier undo tablespace and use new undo.
In that way, we can gain space at the os level.
dont forget to Drop tablespace including contents and datafiles.



Srinivasulu Adiraju | DBA POOL|Tech Mahindra
Mobile: 09881469235
Email: [Email address protected]

-----Original Message-----
From: dgaikwad
[mailto:oracledba-ezmlmshield-x52422684.[Email address protected]
Sent: Tuesday, July 31, 2007 12:07 PM
To: LazyDBA Discussion
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



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page