[无解] 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