> Drop the original undo tablespace: > > DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES; > > Especially on Windows, you might find the datafiles associated with > the undo tablespace remain on disk. If so, restart the instance: How could that be possible? DROP TABLESPACE failed with an error? Yong Huang -- //www.freelists.org/webpage/oracle-l