| Row Movement disabled in Partitioned table [message #671245] |
Sun, 19 August 2018 23:11  |
 |
saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad
|
Senior Member |
|
|
Hi All,
In Production environment ROW_MOVEMENT is disabled on one of the Partition table .
We trying to update the partition key column which causes partition change.
Table Name : CITY_OFFICES
Partition Type : RANGE
Interval :NUMTODSINTERVAL(1,'DAY')
Column Name : TIMESTAMP
Column Datatype : Date
ORA-14402: updating partition key column would cause a partition change
In order to resolve that we are going for enabling the ROW MOVEMENT
ALTER TABLE CITY_OFFICES ENABLE ROW MOVEMENT;
I know that it will resolve my actual issue.
But is there any other impact if I Enable the row movement for that table
?
As that is production environment wants to check before enabling that ?
Please help me
Thanks
Sharavathi
[Updated on: Mon, 20 August 2018 00:03] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
