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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 1.3.1.Final, 1.4.0.Alpha2
    • 0.9.5.Final
    • oracle-connector
    • None
    • debezium oracle connector 0.9.5-Final
      kafka 2.3
      oracle 11.2.0.4

      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

              ccranfor@redhat.com Chris Cranford
              dreamcatchernick Nick Gu (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: