Database Administration (MOSC)

MOSC Banner

FBDA select from <tab> versions scn between, returns scn versions outside range

select versions_startscn,versions_endscn from <tab> versions between scn 17948031196 and 17948217693

returns all rows with null , versions_startscn, versions_endscn. That is expected.

But it also returns 8 updates versions with versions_startscn between scn 17931757407-17917431118 and null versions_endscn.

scn_to_timestamp(17917431118 ) returns ora-8181

So the, Versions between scn 17948031196 and 17948217693, is being ignored ?

I assume because it really want to do a, versions between timestamp , and cannot resolve the time so treats scn value as null ? But that just seems silly, when there is a timestamp between?

Also those 8 version rows should not be there. The FDBA for <tab> has 2 days retention and was last purged 8 hours prior to running the select.

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