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

[无解] 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, salary
  4  FROM emp
  5  VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
  6  WHERE empno = 111;

XID               START_SCN    END_SCN OP EMPNAME                              SALARY
---------------- ---------- ---------- -- -------------------------------- ----------
0700170051040000    3913350            D  Mike                                    555
                               3913350    Mike                                    555

SQL> SELECT  xid, start_scn, commit_scn, operation, logon_user, undo_sql
  2  FROM flashback_transaction_query
  3  WHERE xid = HEXTORAW('0700170051040000');
WHERE xid = HEXTORAW('0700170051040000