全表操作以后数据恢复

update ZZ_USER t1 set t1.NAME  = (select NAME  from ZZ_USER AS OF TIMESTAMP SYSDATE - 4320/ 1440 where t1.id = id)

注意: 两种方式都是恢复到 指定的某一天,但是同时也会覆盖恢复的那天之后的数据

UPDATE ZZ_USER z  SET z.NAME = (SELECT NAME  FROM ZZ_USER AS OF TIMESTAMP TO_TIMESTAMP('20221120 10:00:00','YYYYMMDD HH24:MI:SS') WHERE ID = z.ID)