Resend : Flashback Query/Transaction/Table in *cloned* environment

10g and 11g environments.
Let's say that a Hot Backup of the Database runs from 9pm to 1130pm. We then, beginning at midnight, clone the database (from the backup) to another server. The clone runs till 330am. The clone is then OPENed with RESETLOGS.
We realise that we need to "undo" some transactions executed in the source database at 10pm --- but the "undo" (i.e. flashback query or flashback transaction or flashback table) is to be done only in the clone.
Assume that undo_retention is 3hours.
Can we use flashback query/transaction/table in the cloned environment after the resetlogs ?
Can we be sure that Oracle doesn't "expire" the undo extents (as significant time has elapsed between 10pm and 330am) ? What if undo_retention is 8hours ?
What if the clone to the new server was done 12 hours later (in both undo_retention 3hours and 8hours scenarios) ?

Hemant K Chitale
Senior Product Specialist
GTO - TSD - Group Functions (Finance)
Standard Chartered Bank
7 Changi Business Park Crescent
Singapore 486028

This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.

--
http://www.freelists.org/webpage/oracle-l