create new undo table space with wat ever the size u want
alter system set undo_tablespace=<new tablespace name > scope=spfile;
then dorp the old one
(if there any transactions are going on in old undo tablespace then it
automatically will go on to offline pending status when u querry
dba_rollback_segs table when the transation is completed u can drop
the old one)
check DBA fundamentals I if are having any dout.
radian7 wrote:
> Hi
>
> I have oracle 9.2
>
> I use oracle in Automatic Undo Management Mode.
> Undo Tablespace have one file.
> That file is very big...
> How can I decrease size of that file ?
>
> Thanks
Received on Thu Jul 27 2006 - 02:53:30 CDT
