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

From: Antonio Dell'elce <antonio_at_dellelce.com>
Date: Sun, 10 Oct 2004 20:49:19 GMT
Message-ID: <jfhad.34218$N45.954177@twister2.libero.it>

Joel Garry wrote:

> "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.
> 

The problem was only a "bureaucratic" one... of course LMTs are better !

Thanks all for your sugestions!

      Antonio

-- 
Antonio Dell'elce
   http://www.dellelce.com/MyHome/

Received on Sun Oct 10 2004 - 15:49:19 CDT