[Home] [Help]
select ast."APPLY_NAME",ast."XIDUSN",ast."XIDSLT",ast."XIDSQN",ast."FIRST_SCN",ast."MESSAGE_COUNT",ast."FIRST_MESSAGE_CREATE_TIME",ast."SPILL_CREATION_TIME",ast."FIRST_POSITION",ast."TRANSACTION_ID"
from DBA_APPLY_SPILL_TXN ast, ALL_APPLY aa
where aa.apply_name = ast.apply_name
SELECT AST."APPLY_NAME"
, AST."XIDUSN"
, AST."XIDSLT"
, AST."XIDSQN"
, AST."FIRST_SCN"
, AST."MESSAGE_COUNT"
, AST."FIRST_MESSAGE_CREATE_TIME"
, AST."SPILL_CREATION_TIME"
, AST."FIRST_POSITION"
, AST."TRANSACTION_ID"
FROM DBA_APPLY_SPILL_TXN AST
, ALL_APPLY AA
WHERE AA.APPLY_NAME = AST.APPLY_NAME
|
|
|
|