Hi,
In one of the single instance support environments in our 11gR2 database, I'm trying to drop an unwanted extra undo tablespace datafile but it won't let me do it as the file is not empty. There are two undo tablespaces in that database because it was refreshed from a 2-node RAC Prod environment. Each of the two tablespaces has two datafiles but I would like to drop one datafile each to release unused disk space. Starting with the non-current tablespace, I tried to drop the second datafile. There are however no active segments in the datafile, they are all either unexpired or expired.
Although I have not tried dropping the entire tablespace, but I suspect that i am likely to have a problem with that too since the datafile is still considered 'not empty'. I will appreciate some advice on how to drop these datafiles please.
Please note that I've already tried creating a 3rd tablespace, switched it to be current, tried dropping the second file in each of the first two tablespaces, but unable.
Thank you.