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

no snapshot found based on specified time

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Issue Links

          duplicates

          Bug - A problem that impairs or prevents the functions of the product. DBZ-1446 Oracle throw "no snapshot found based on specified time" when running flashback query

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: