Questions about parsing oracle log files

最强男人

Questions about parsing oracle log files
Parsed the oracle log file, but the content in v $ logmnr_contents is as follows:
Is the name empty? Type
----------------------------------------- --------- ---------------------
SCN NUMBER
CSCN NUMBER
TIMESTAMP DATE
COMMIT_TIMESTAMP DATE
THREAD # NUMBER
LOG_ID NUMBER
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
PXIDUSN NUMBER
PXIDSLT NUMBER
PXIDSQN NUMBER
RBASQN NUMBER
RBABLK NUMBER
RBABYTE NUMBER
UBAFIL NUMBER
UBABLK NUMBER
UBAREC NUMBER
UBASQN NUMBER
ABS_FILE # NUMBER
REL_FILE # NUMBER
DATA_BLK # NUMBER
DATA_OBJ # NUMBER
DATA_OBJD # NUMBER
SEG_OWNER VARCHAR2 (32)
SEG_NAME VARCHAR2 (256)
SEG_TYPE NUMBER
SEG_TYPE_NAME VARCHAR2 (32)
TABLE_SPACE VARCHAR2 (32)
ROW_ID VARCHAR2 (19)
SESSION # NUMBER
SERIAL # NUMBER
USERNAME VARCHAR2 (30)
SESSION_INFO VARCHAR2 (4000)
TX_NAME VARCHAR2 (256)
ROLLBACK NUMBER
OPERATION VARCHAR2 (32)
OPERATION_CODE NUMBER
SQL_REDO VARCHAR2 (4000)
SQL_UNDO VARCHAR2 (4000)
RS_ID VARCHAR2 (32)
SEQUENCE # NUMBER
SSN NUMBER
CSF NUMBER
INFO VARCHAR2 (32)
STATUS NUMBER
REDO_VALUE RAW (4)
UNDO_VALUE RAW (4)
SQL_COLUMN_TYPE VARCHAR2 (32)
SQL_COLUMN_NAME VARCHAR2 (32)
REDO_LENGTH NUMBER
REDO_OFFSET NUMBER
UNDO_LENGTH NUMBER
UNDO_OFFSET NUMBER

My question is, what are these columns for? How do I extract the desired insert, update, delete information from v $ logmnr_contents?
See the following message:
SESSION_INFO
-------------------------------------------------- ------------------------------
SQL_REDO
-------------------------------------------------- ------------------------------
004e81c00000300940829000101010004041d00000300c00829000101010002201d00000300ec080
4000101010000 ') and ROWID =' AAAABIAABAAACxKAAA ';

login_username = SYS client_info = OS_username = NEU-14ACA061527\Administrator Machin
e_name = WORKGROUP\NEU-14ACA061527
update "SYS". "OBJ $" set "OBJ #" = '4460', "DATAOBJ #" = NULL, "TYPE #" = '11', "CTI
ME "= TO_DATE ('12 -May--16 ',' DD-MON-RR ')," MTIME "= TO_DATE ('05 -May--17', 'DD-MO
N-RR '), "STIME" = TO_DATE ('05 -1Jan-17', 'DD-MON-RR'), "STATUS" = '1', "FLAGS" =
'0', "OID $" = NULL, "SPARE1" = '6', "SPARE2" = '65535' where "OBJ #" = '4460' and
I still don't know how to extract the data. That is to get the data information of the insert delete update.
Please advise! !! !!

My purpose is to extract data incrementally


Why is the user in the parsed file only sys and only the table space, and the table name is not visible?

6263654

The table name is in V$v$logmnr_contents, and the garbled code above you can see the specific name because you did not load the data dictionary or use online analysis.