Weird question
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Sun, 23 Oct 2022 02:17:07 -0400
Message-ID: <CAP79kiSw=-P-kWTAu0K04U+bNB08GXdHwXcATmso3vfXX12Qmg_at_mail.gmail.com>
Is there any way to force Oracle to "touch" every block in a table and update/refresh the SCN without running an update/delete?
Date: Sun, 23 Oct 2022 02:17:07 -0400
Message-ID: <CAP79kiSw=-P-kWTAu0K04U+bNB08GXdHwXcATmso3vfXX12Qmg_at_mail.gmail.com>
Is there any way to force Oracle to "touch" every block in a table and update/refresh the SCN without running an update/delete?
Does an update/delete followed by a rollback cause the SCN to advance, or does the rollback put the SCN back as well? (I'm assuming it requires a commit to advance the SCN)
THe genesis of this question comes from a situation similar to this:
Flashback Version Query Fails With Error - ORA-01555 After 18c Upgrade (Doc ID 2596214.1)
SOLUTION Run CTAS of each table to generate new block scns for each block. Making the block scn current will stop the ORA-1555 errors.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 23 2022 - 08:17:07 CEST