Oracle Database Discussions

Dear all,

I am using oracle 9i which is running in solaris 9.I having a undo tablespace called undotbs1 which is sized around 8.5GB and

undo_retention parameter has been set to *10800* that i want to reduce to 2000 and i want to create a undo tablespace of size around 3GB and set stated as default undo tablespace for the database.

alter system set undo_retention=2000 scope=both
create undo tablespace undotbs2 datafile 'file_location' size 3G
alter system set undo_tablespace=undotbs2 scope=both

drop tablespace undotbs1 including contents and datafiles

Will there be any problem if i do so....I am asking because my current undo tablespace size is 8.5GB ?

Thanks and Regards
Monoj Das