Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can get query on table by scn number but not with date

orasiyaSep 12 2020 — edited Sep 14 2020

Dear friends,

I did enable flash technology for our production database 18c.

when i executed following sql statement

-- for getting last 15 minute data

select * from aa AS OF TIMESTAMP TO_DATE('12/09/2020 16:15:00','DD/MM/YYYY HH24:MI:SS')

I get error

ORA-01466: unable to read data - table definition has changed

select current_scn from v$database

11130364665

but when execute the query

select * from aa AS OF scn  (11130364665 - 100000000)

I can get the correct result set.

why ???

Not : select scn_to_timestamp(33330364665 - 100000000) from dual

resulted in wrong date 12.06.2052 19:17:51,000000000

regards

siya

Added on Sep 12 2020

#general-database-discussions

10 comments

2,805 views