Re: migrating from LMT to DMT in oracle and downtime

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 20 Jul 2005 17:35:49 +0200
Message-ID: <42de7057$0$21249$9b4e6d93@newsread2.arcor-online.net>

Chuck schrieb:
> "Ken" <sid999_at_hotmail.com> wrote in news:1121868564.377904.45960
> @g14g2000cwa.googlegroups.com:
>
>

>>I am wishing to migrate to LMT's in an Oracle 9.2 database. I am trying
>>to find out if this can be done with users still accessing data ie
>>while the database is online. I would appreciate any comments regarding
>>this and other problems encountered. We are probably going to have to
>>use dbms_space_admin.tablespac­e_migrate_to_local due to lack of
>>diskspace. Also am I able to move tables to a new tablespace without
>>any downtime ?I would appreciate any response on this subject. Thanks

>
>
>
> Yes. Provided you have enough disk for double the size of your largest
> tablespace.
>
>
> 1) Create new tablespace as LMT.
>
> 2) Move tables to new tablespace using "ALTER TABLE table_name MOVE
> tablespace_name ONLINE;"
>
> 3) Drop old tablespace.

Its not correct, AFAIK the ONLINE option is not allowed by MOVE TABLE ( though documentation states that is possible ).

Best regards

Maxim Received on Wed Jul 20 2005 - 10:35:49 CDT