prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
Part of this package was developed before the 10g release of command-line Flashback capabilities ... and is now obsolete. TRANSACTION_BACKOUT is a new capability added in 11g and is priceless.
Constants for Transaction Backout
Default: Backs out specified transactions, expected to have no dependent transactions.
If dependents an exception is raised and the error can be found in DBA_FLASHBACK_TXN_REPORT.
Backs out specified transactions, ignoring dependent transactions. Backout happens in reverse order of commit times.
Backs out changes to nonconflicting rows. The database remains consistent but atomicity is lost.
Backs out specified transactions and all dependent transactions in a post-order fashion (children first: parents second).
Data Types Used
CREATE OR REPLACE TYPE "SYS"."TXNAME_ARRAY" AS VARRAY(100) OF VARCHAR2(256);
Time specified is too old
Invalid system change number specified
User cannot begin read-only or serializable transactions in Flashback mode
User cannot enable Flashback within an uncommitted transaction
User cannot enable Flashback within another Flashback session
SYS cannot enable Flashback mode
Related Sysem Privileges
FLASHBACK ANY TABLE
Owned by SYS with EXECUTE granted to MDSYS and the DBA role