We are creating a new 8i database and wanted to go with LMT for all our tablespaces. Can we have SYSTEM tablespace as LMT? If yes, is it better to go with LMT or DMT?
Thanks.
Printable View
We are creating a new 8i database and wanted to go with LMT for all our tablespaces. Can we have SYSTEM tablespace as LMT? If yes, is it better to go with LMT or DMT?
Thanks.
LMT is not available on 8i for SYSTEM tablespace, it's available on 9i
Good luck
Thanks for the quick reply. That confirms my research.
I read somewhere that on 9i if you make SYSTEM LMT you will not be able to have any DMTs, which makes sense since Oracle is going away from DMTs in the database.
axe, I'll confirm your last post. This is correct. Tried it myself.