Srinivasulu,

If you want to use ALTER DATABASE DATAFILE... command , you need to check -


SELECT TABLESPACE_NAME,BYTES/1024/1024 MB
FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME =(SELECT VALUE FROM V$PARAMETER WHERE
NAME='undo_tablespace')

then use the command by specifying a proper size.









----- Original Message -----
From: "srinivasulu "
<oracledba-ezmlmshield-x39524145.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, July 31, 2007 4:10 PM
Subject: RE: Resize UNDOTBS01.DBF


>
> 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.
>
> ============================================================================================================================
>
>
> ---------------------------------------------------------------------
> 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