| Author |
migrating from LMT to DMT in oracle and downtime
|
|
|
| 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=ADe_migrat
e_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
| |
|
| "Ken" <sid999@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.
| |
| Maxim Demenko 2005-07-20, 11:23 am |
| Chuck schrieb:
> "Ken" <sid999@hotmail.com> wrote in news:1121868564.377904.45960
> @g14g2000cwa.googlegroups.com:
>
>
>
>
>
> 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
| |
|
|
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. tablespac=ADe_migrat
e_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.
| |
| chao_ping 2005-07-24, 8:24 pm |
| Hi, Noons,
We are planning to do this convertion on a big production box,
because we suffered from ST enqueue.
I don't see any known issue in metalink, can you point some known
issue with this package?
Thanks
by the way, alter table xxx move online is avaliable, but only limited
to IOT table.
| |
|
| chao_ping wrote:
> Hi, Noons,
> We are planning to do this convertion on a big production box,
> because we suffered from ST enqueue.
> I don't see any known issue in metalink, can you point some known
> issue with this package?
>
>
Do a search on LMT in bug db and read the results. Most of the public
bugs are with those who used the package.
I never used it and don't plan to. It doesn't even do a
good job of converting to a proper LMT: Jonathan showed a while ago
some of the problems it has.
My advice is: bite the bullet and do a refresh. It doesn't really take
that much longer than a conversion and you end up with something that
works the way it was designed to.
And please, do NOT leave the system tablespace in DMT while the rest
is in LMT: it's really not a good idea. Although some claim that LMT
and system tablespace are bad: invariably, these are the ones who used
conversion instead of refresh...
|
|
|
|