Database Administration (MOSC)

MOSC Banner

Flashback Archive : can VERSIONS_STARTTIME be more precise than seconds ?

Hello,

I manage a database running on 11gR2 with Flashback Archive enabled for some tables.

I track the changes through Flashback Version queries like :

SELECT versions_startscn,

      versions_endscn,

      versions_xid,

      versions_operation,

      versions_starttime,

      col1

FROM  schema.t1

      versions between scn 305797262 and 305797267

      where col1= '62793';

But I can't manage to get the VERSIONS_STARTTIME with milliseconds. The better I get is, for example :

14-OCT-2020 16:33:23.000

or

14-OCT-2020 16:13:00.000


The documentation says that VERSIONS_STARTTIME is a TIMESTAMP column but maybe the Flashback Archive feature is not recording the date and time with milliseconds.

Do you know where I could find such information ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center