If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

prob convert SYSTEM tablespace into locally managed one..help?

hi,

I have upgraded my 8.1.7.0 db into 9.2.0.4 in Tru64 unix platform..
however since in 8i my db was in DMT and now I wish to convert those into LMT...there's no prob convert other tablespaces except SYSTEM which throw me the following error:

That migrate package is worthless, the only thing you get out of it is not having to access the data dictionary. You still are not able to take advantage of the uniform / system extent,segment functionality. After you migrate you will still see your TBS extent management as USER defined.

Oracle it's not just a database it's a lifestyle!
--------------BTW....You need to get a girlfriend who's last name isn't .jpg

I see your point thanks for pointing that out to me...
hmm...So I guess if we really going to harvest the benefit of LMT either we hv to recreate a new TS and migrate the tables from OLD TS into it right?