ENABLE_AT_SYSTEM_CHANGE_NUMBER Procedure

This procedure takes an SCN as an input parameter and sets the session snapshot to the specified number.

In the Flashback mode, all queries return data consistent as of the specified wall-clock time or SCN.

Syntax

DBMS_FLASHBACK.ENABLE_AT_SYSTEM_CHANGE (

query_scn IN NUMBER);

Parameters

Table 16-4 shows the parameters for the ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure.

Table 16-4 ENABLE_AT_SYSTEM_CHANGE_NUMBER Procedure Parameters

Parameter	Description
query_scn	The system change number (SCN), a version number for the database that is incremented on every transaction commit.