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),
上一篇:联机热备份失败后,如何打开数据库?
下一篇:关于库存余额、财务收支余额的计算
|