当前位置: 代码迷 >> 综合 >> [无解] Oracle 12c 可插拔数据库中遭遇 ORA-01295
  详细解决方案

[无解] Oracle 12c 可插拔数据库中遭遇 ORA-01295

热度:71   发布时间:2024-01-15 19:59:55.0

[无解] Oracle 12c 可插拔数据库中遭遇 ORA-01295

今天在Oracle 12c Pluggable Database环境中,准备 Flashback Transaction Query 案例时,遇到了 ORA-01295的错误。

SQL> SELECT versions_xid XID, versions_startscn START_SCN,2    versions_endscn END_SCN, versions_operation OPERATION,3    empname, salary4  FROM emp5  VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE6  WHERE empno = 111;XID               START_SCN    END_SCN OP EMPNAME                              SALARY
---------------- ---------- ---------- -- -------------------------------- ----------
0700170051040000    3913350            D  Mike                                    5553913350    Mike                                    555SQL> SELECT  xid, start_scn, commit_scn, operation, logon_user, undo_sql2  FROM flashback_transaction_query3  WHERE xid = HEXTORAW('0700170051040000');
WHERE xid = HEXTORAW('0700170051040000