Hm, this is new to me. Are you sure about your results? I know you can specify EXTENT MANAGEMENT LOCAL, but only in the "default temporary tablespace" part of the CREATE DATABASE command. And of course, LMT then applies only to the default TEMP tablespace, not to SYSTEM tablespace itself.Quote:
Originally posted by TimHall
It works! I now have a 9i instance with a Locally Managed System Tablespace.
Also, on "9i New Features for Administrators" ILT we were explicitely told that system TS can not be LMT. And the "9i Database Administration" manual explicitely states:
"The SYSTEM tablespace is always dictionary managed."
http://download-west.oracle.com/otnd...aces.htm#19132
So once again: are you sure you sucessfully created SYSTEM TS as LMT? Have you verified that it really *is* a LMT and not perhaps that some of the utilities/tools simply erroneously report it as being LMT, while in fact it is normal dictionary managed TS?