Re: migrating from LMT to DMT in oracle and downtime

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