Home » RDBMS Server » Server Administration » alter table ... enable row movement (DB all releases)
alter table ... enable row movement [message #656794] Wed, 19 October 2016 08:50 Go to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Just a minor question - does anyone know what enabling row movement actually does? Or how to see if row movement has been enabled for a table? As far as I can tell, it has no real effect at all. It is just that if you don't enable it, some things won't work. Right now, I can think of three cases where it is needed:

A partitioned table, if updating the partitioning key
Before using ALTER TABLE ... SHRINK SPACE
Some uses of DBMS_REDEFINITION

I'm sure there are others, I'ld be interested to know them all.

This is of no practical significance - I'm just curious. Thank you for any insight.

[Updated on: Wed, 19 October 2016 08:51]

Report message to a moderator

Re: alter table ... enable row movement [message #656801 is a reply to message #656794] Wed, 19 October 2016 09:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Just a minor question - does anyone know what enabling row movement actually does?
It enables rows to move. Smile
This feature was introduced to forbid some actions because some (I hope old) applications store row ids and access rows with this "key" to be faster.

Quote:
Right now, I can think of three cases where it is needed:
ALTER TABLE MOVE is another one.

Re: alter table ... enable row movement [message #656804 is a reply to message #656801] Wed, 19 October 2016 11:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
ALTER TABLE MOVE is online now, I just put up a little blog about it Smile
Re: alter table ... enable row movement [message #656825 is a reply to message #656804] Thu, 20 October 2016 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forgot to answer the question: "Or how to see if row movement has been enabled for a table?":
%_TABLES.ROW_MOVEMENT

Re: alter table ... enable row movement [message #656844 is a reply to message #656825] Thu, 20 October 2016 06:56 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Stupid of me. Ta.
Previous Topic: Default unique index on primary key.
Next Topic: SYSAUX tablespace getting 99%
Goto Forum:
  


Current Time: Thu Mar 28 14:03:37 CDT 2024