Migration from Dictionary Managed to Locally managed tablespaces
I have a situation where we have a database that has several Dictionary Managed tablespaces, many of them full of indexes. I believe this may be causing some performance issues and I would like to convert them to Locally Managed tablespaces. I have read in some articles that it is not recommended to do this. I've also read that one needs to make sure there is enough freespace to store the bit maps, but am unsure how much space is needed. So I guess to sum it up, I would like to find out the recommend method for proceeding. I would really like to