90. You are working on an Oracle Database 10g database. For which pur
poses would you use the Flashback Transaction Query feature? (Choose
all that apply)
A. To recover a dropped table.
B. To recover a dropped schema.
C. To recover data from a truncated table.
D. To view changes made by all the transactions during a given period
of time.
E. To view changes made by a single transaction during a given period
of time.
Answer: D, E
查看视图,每个事务都对应相同的XID.
Sql>select xid,operation,commit_scn,undo_sql
From flashback_transaction_query
Where xid in(select version_xid from tmp1 where versions between scn
minvalue and maxvalue);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717991/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
