In my Prod database there is undo tablepsace UNDOTBS01.DBF.
1Q) Now i created undo tablepsace 'UNDOTBS02.DBF' and My Prod database must use UNDOTBS02.DBF But should not use UNDOTBS01.DBF and not by deleting UNDOTBS01.DBF. How to do ?
2Q) In my PROD database if we have 5 undo tablespaces then how to find which undo tablespace is used by Prod database ?
Kindly assist, Thanks in advance.