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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Oct 2004 14:54:59 +0000 (UTC)
Message-ID: <ck3lc3$n3r$1@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.

I don't know if this is legal, but I can't think of any other high-speed option that could solve your problem.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th





"Antonio Dell'elce" <antonio_at_dellelce.com> wrote in message
news:415C2DCC.3090009_at_dellelce.com...


> Dear all,

>

>   By "error" I created tablespaces (including SYSTEM) to be LMT...

> unfortunately the customer does not allow this at this point, I MUST

> "migrate" (someway) to DMT, any suggestions? I MUST migrate two

> instances totaling about two terabytes in possibly 24 hours or not much

> more..... I don't have enough resources  to do an export/db (re)creation

> and import in 24 hours.

>

> Thank you all!

>

> PS  Hardware platform is a HP Integrity Superdome partition

>      with 4 procs 16 gigs ram (IA64) with Symmetrix storage.

>

>

>

> -- 

> Antonio Dell'elce

>    http://www.dellelce.com/MyHome/

>

Received on Thu Oct 07 2004 - 09:54:59 CDT