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

no snapshot found based on specified time

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.0.2.Final
    • oracle-connector

      the sql

      SELECT TIMESTAMP_TO_SCN(MAX(last_ddl_time)) FROM all_objects WHERE (owner = 'AAA' AND object_name = 'XXX')
      may occur error
      Caused by: java.sql.SQLException: ORA-08180: no snapshot found based on specified time
      ORA-06512: at "SYS.TIMESTAMP_TO_SCN\", line 1

              Unassigned Unassigned
              happyapple668 Gavin wang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: