DBMS_FLASHBACK, 2 of 5

ENABLE_AT_TIME Procedure

This procedure enables Flashback for the entire session. The snapshot time is set to the SCN that most closely matches the time specified in query_time.

Syntax

DBMS_FLASHBACK.ENABLE_AT_TIME (

query_time   IN TIMESTAMP);

Parameters

Table 16-3 shows the parameters for the ENABLE_AT_TIME procedure.

Table 16-3 ENABLE_AT_TIME Procedure Parameters

Parameter Description

Parameter	Description
`query_time`	This is an input parameter of type `TIMESTAMP.` A time stamp can be specified in the following ways: Using the TIMESTAMP constructor: Example: `execute dbms_flashback.enable_at_time(TIMESTAMP '2001-01-09 12:31:00').` Use the NLS format and supply a string. The format depends on the NLS settings. Using the `TO_TIMESTAMP` function: Example: `execute dbms_flashback.enable_at_time(TO_TIMESTAMP('12-02-2001 14:35:00', 'DD-MM-YYYY HH24:MI:SS')). Y`ou provide the format you want to use. This example shows the `TO_TIMESTAMP` function for February 12, 2001, 2:35 PM. If the time is omitted from query time, it defaults to the beginning of the day, that is, 12:00 A.M. Note that if the query time contains a time zone, the time zone information is truncated.

query_time

This is an input parameter of type TIMESTAMP. A time stamp can be specified in the following ways:

Using the TIMESTAMP constructor: Example: execute dbms_flashback.enable_at_time(TIMESTAMP '2001-01-09 12:31:00'). Use the NLS format and supply a string. The format depends on the NLS settings.

Using the TO_TIMESTAMP function: Example: execute dbms_flashback.enable_at_time(TO_TIMESTAMP('12-02-2001 14:35:00', 'DD-MM-YYYY HH24:MI:SS')). You provide the format you want to use. This example shows the TO_TIMESTAMP function for February 12, 2001, 2:35 PM.

If the time is omitted from query time, it defaults to the beginning of the day, that is, 12:00 A.M.

Note that if the query time contains a time zone, the time zone information is truncated.