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