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

"Antonio Dell'elce" <antonio_at_dellelce.com> wrote in message news:415C2E71.9090909_at_dellelce.com...
> Antonio Dell'elce wrote:
>> 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.
>>
>>
>>
> Addendundum Oracle version is 9.2.0.5.0.
>
> A.
>
> --
> Antonio Dell'elce
> http://www.dellelce.com/MyHome/
> Ph: (IT) +39 347 6761377 (UK) +44 7816 216 963
> "Timendi causa est nescire"

if your system tablespace is LMT you are stuffed, need to recreate from scratch.

if it isnt, go look at dbms_space_admin.migrate_to_dict (i think) Received on Thu Sep 30 2004 - 13:29:07 CDT