Re: URGENT: Migrating Locally Managed Tablespaces to DICTIONARY!!!!

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<ck3lc3$n3r$1_at_titan.btinternet.com>...
> Since the SYSTEM tablespace is LMT, you
> cannot migrate anything to DMT (you can only
> have read-only DMTs on a database with an
> LMT SYSTEM).
>
> However, you could create a barebones database
> with a DMT for SYSTEM, and use transportable
> tablespaces to transport all the files from the old
> databases to the new - then migrate them to DMT
> after they arrive.

Or even not physically move them, just read-only, generate TTS on old db, plug into new db, create new DMT in new db and ctas the tables: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#6039

Still wondering what the problems with LMT's are.

jg

--
@home.com is bogus. "It took a long time, but that's because it's a
complicated criminal case and because of the sheer volume of criminal
conduct" - Sanjay Bhandari
"While he was there, he tried to correct what he viewed as incorrect
business practices." - William Braniff 
http://www.signonsandiego.com/uniontrib/20041007/news_1n7peregrine.html