It is not possible to update a record when filtering by partition.
Please see below the steps to replicate the problem:
1] Create a table with a partition:
CREATE TABLE SCOTT.HASH_PART
(
PROF_HISTORY_ID NUMBER (10),
PERSON_ID NUMBER (10) NOT NULL,
ORGANIZATION_ID NUMBER (10) NOT NULL,
RECORD_DATE DATE NOT NULL,
PROF_HIST_COMMENTS VARCHAR2 (2000 BYTE)
)
TABLESPACE USERS
PARTITION BY HASH (PROF_HISTORY_ID)
PARTITIONS 3
STORE IN (tablespace1, tablespace2, tablespace3)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
2] Insert some data:
INSERT INTO SCOTT.HASH_PART (PROF_HISTORY_ID,
PERSON_ID,
ORGANIZATION_ID,
RECORD_DATE,
PROF_HIST_COMMENTS)
VALUES (5,
2,
6,
TO_DATE ('01/01/1900 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),
'2');
INSERT INTO SCOTT.HASH_PART (PROF_HISTORY_ID,
PERSON_ID,
ORGANIZATION_ID,
RECORD_DATE,
PROF_HIST_COMMENTS)
VALUES (5,
3,
3,
TO_DATE ('01/02/1900 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),
'3');
COMMIT;
/
3] Then go to the Schema Browser and select the table hash_part.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center