If you have a table partitoned on a certain column and on one of your loads you try to update that column on already existing records. You might run into this oracle error
The above error was caused because when you updated the record, it now belongs to a different partition but since row movement between partitions is not enabled on the table, you got that error.
It's easy to solve this problem. Just enable row movement on the table by executing the following command. You need to be logged in as the owner schema of that table or have enough privileges to do so.
Thanks,
Zooz
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 17 weeks ago
2 years 22 weeks ago
2 years 22 weeks ago
2 years 23 weeks ago
2 years 24 weeks ago
2 years 24 weeks ago
2 years 26 weeks ago
2 years 28 weeks ago
2 years 31 weeks ago
2 years 37 weeks ago