SQL & PL/SQL

Hi,

Iam trying to update partitioned table as below.

Please refer
http://www.psoug.org/reference/update.html.

In the above site there is a reference to update the partitioned table. But when i try to run the below update
i get the error message "missing SET keyword"


UPDATE /*+ PARALLEL(UB,8) NOLOGGING */ PART_B.PART_B_FACT_STAGE UB PARTITION (THRU_DT_200201)
SET UB.NOT_FINAL_ID = (SELECT /*+ PARALLEL(FD,8) */
FD.NOT_FINAL_ID
FROM PART_B.part_b_final_action_dedup FD
WHERE UB.rowid = FD.ptb_row_id)
WHERE UB.rowid IN
(SELECT ptb_row_id FROM PART_B.part_b_final_action_dedup)

Thanks in advance