Converting Dictionary Manged tablspaces to Locally Managed Tablespaces.
600574Jan 8 2010 — edited Jan 20 2010Hi,
Recently I moved my production database from oracle 9.2.04 on windows 32 bit to 10.2.0.3 Windows 64 bit. Some of my tablespaces extent management are dictionary managed table space. I got two questions
1) What’s the recommendation for SYSTEM tables space extent management, what’s the recommendation for other data files extent management.
2) How to convert Dictionary managed to Local managed table spaces, is there any negative impacts by this conversion?
TABLESPACE_NAME EXTENT_MAN ALLOCATIO
------------------------------ ---------- ---------
SYSTEM DICTIONARY USER
TOOLS DICTIONARY USER
USERS DICTIONARY USER
Thank you