Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1446

Oracle throw "no snapshot found based on specified time" when running flashback query

    XMLWordPrintable

    Details

      Description

      i found in debezium-oracle connector 0.9.5-final code OracleSnapshotChangeEventSource.java line 111

      Optional<Long> latestTableDdlScn = getLatestTableDdlScn(ctx);
      

      my last_ddl_time in the table is very old when i run this line it will throw
      ORA-08180: no snapshot found based on specified time
      ORA-06512: at "SYS.TIMESTAMP_TO_SCN", line 1

      is any way to avoid this error?

      Thanks

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ccranfor Chris Cranford
              Reporter:
              dreamcatchernick Nick Gu (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: