DROP TABLE LOGMNR_DETAILS CASCADE CONSTRAINTS ;
CREATE TABLE LOGMNR_DETAILS (
SCN NUMBER,
TIMESTAMP DATE,
THREAD# NUMBER,
LOG_ID NUMBER,
XIDUSN NUMBER,
XIDSLT NUMBER,
XIDSQN 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 (32),
SEG_TYPE NUMBER,
SEG_TYPE_NAME VARCHAR2 (32),
TABLE_SPACE VARCHAR2 (32),
ROW_ID VARCHAR2 (19),
SESSION# NUMBER,
SERIAL# NUMBER,
USERNAME VARCHAR2 (32),
SESSION_INFO VARCHAR2 (4000),
ROLLBACK NUMBER,
OPERATION VARCHAR2 (32),
SQL_REDO VARCHAR2 (4000),
SQL_UNDO VARCHAR2 (4000),
RS_ID VARCHAR2 (32),
SSN NUMBER,
CSF NUMBER,
INFO VARCHAR2 (32),
STATUS NUMBER,
PH1_NAME VARCHAR2 (32),
PH1_REDO VARCHAR2 (4000),
PH1_UNDO VARCHAR2 (4000),
PH2_NAME VARCHAR2 (32),
PH2_REDO VARCHAR2 (4000),
PH2_UNDO VARCHAR2 (4000),
PH3_NAME VARCHAR2 (32),
PH3_REDO VARCHAR2 (4000),
PH3_UNDO VARCHAR2 (4000),
PH4_NAME VARCHAR2 (32),
PH4_REDO VARCHAR2 (4000),
PH4_UNDO VARCHAR2 (4000),
PH5_NAME VARCHAR2 (32),
PH5_REDO VARCHAR2 (4000),
PH5_UNDO VARCHAR2 (4000))
TABLESPACE USERS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 40960
NEXT 1146880
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 505
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
|
