Enable row movement [message #336564] |
Mon, 28 July 2008 02:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
eigeneachse
Messages: 37 Registered: July 2008
|
Member |
|
|
Hi@all,
i just wanted to know if i need to have a downtime while changing a table to have row movement enabled with the statement.
alter table TABLE enable row movement
i have read, that i have to recompile all dependent packages.
so are there any things i have to know?
thanks in advance.
regards
eigeneachse
|
|
|
|
Re: Enable row movement [message #336576 is a reply to message #336565] |
Mon, 28 July 2008 04:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
eigeneachse
Messages: 37 Registered: July 2008
|
Member |
|
|
Michel Cadot wrote on Mon, 28 July 2008 10:03 | Quote: | i have read, that i have to recompile all dependent packages.
|
You don't have to, they will be automatically recompiled at next call.
Quote: | so are there any things i have to know?
|
Do you know the implications to enable this?
Regards
Michel
|
i know about working with rowid's would not be possible after the change. this doesn't matter for me.
The most interesting point for me is, do need to have an downtime for this change?
regards
eigeneachse
|
|
|
|
|