Do we need to convert Tablespaces to LOCALLY Managed after upgrade to Oracle 10g?
I have upgraded and migrated our customer database from Oracle 8i on HP-UX 11.11 (PA-RISC 64-Bit) to Oracle 10g R2 on HP-UX 11.31 on HP-UX (Itanium IA64).
The system is Live now. I want to know if it is recommended/mandatory to convert the Tablespaces to LOCALLY Managed Tablespaces. This is not documented in the upgrade document.
Plz advice.
Rgds,
Thiru