Home » RDBMS Server » Server Administration » Enable row movement (Oracle 9.2.0.6.0)
Enable row movement [message #336564] Mon, 28 July 2008 02:59 Go to next message
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 #336565 is a reply to message #336564] Mon, 28 July 2008 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: Enable row movement [message #336576 is a reply to message #336565] Mon, 28 July 2008 04:05 Go to previous messageGo to next message
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
Re: Enable row movement [message #336591 is a reply to message #336576] Mon, 28 July 2008 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No downtime, it is just an update in dictionary (well strictly speaking table is not updatable during 1 ro 2 milliseconds).

Regards
Michel
Re: Enable row movement [message #336592 is a reply to message #336591] Mon, 28 July 2008 05:41 Go to previous message
eigeneachse
Messages: 37
Registered: July 2008
Member
hi michel,
thank you very much for this information.

regards

eigeneachse

[Updated on: Mon, 28 July 2008 05:41]

Report message to a moderator

Previous Topic: low disk space error ora 9i
Next Topic: pfile at remote location..
Goto Forum:
  


Current Time: Wed Dec 07 10:31:21 CST 2016

Total time taken to generate the page: 0.08184 seconds