如何查询DML操作的详细记录

可以通过flashback_transaction_qurey视图查询

eg:

SQL> desc flashback_transaction_query

Name                        Null?                            Type

----------------------------------------- -------- ----------------------------

XID                                   RAW(8)

START_SCN                   NUMBER

START_TIMESTAMP      DATE

COMMIT_SCN                NUMBER

COMMIT_TIMESTAMP    DATE

LOGON_USER               VARCHAR2(30)
UNDO_CHANGE#           NUMBER

OPERATION                  VARCHAR2(32)

TABLE_NAME               VARCHAR2(256)

TABLE_OWNER              VARCHAR2(32)

ROW_ID                         VARCHAR2(19)

UNDO_SQL                  VARCHAR2(4000)