Re: migrating from LMT to DMT in oracle and downtime

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 20 Jul 2005 21:57:49 -0700
Message-ID: <1121921869.026309.29800@z14g2000cwz.googlegroups.com>

Ken wrote:
> 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.tablespace_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, you can do all that. But I strongly suggest you do NOT use that package unless you are absolutely sure you have patched up your Oracle RDBMS to the latest levels and investigated all bugs in Metalink on DMT->LMT conversion.

Or you can do what I do: byte the bullet ONCE, do a complete export/re-create/import and stop having headaches. Received on Wed Jul 20 2005 - 23:57:49 CDT