CREATE UNTO TABLESPACE UNDO_NEW DATAFILE ..... SIZE 4 GB;
ALTER SYSTEM SET UNDO_TABLESPACE='UNDO_NEW';
wait for last transaction using the old tablespace is finished
DROP TABLESPACCE OLD_UNDO;
Jan
cnwy_at_263.net napísal(a):
> Hello,
>
> Currently, my undotablespace is autoextented to 16G in Oracle 9i. It is
> too large to my application, so I want to shrink it to a appropriate
> size 4G, I am not sure whether the way switching current undo
> tablespace(16g) to a new one(4G) is the best?
>
> Any suggestions will be very appreciated !
>
> wy
Received on Fri Dec 09 2005 - 09:44:28 CST
