| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: stange rollback behavior
Read consistent exports can get tricky....probably the best method is to
pick only those tables and objects that are required for a consistent view
and export only those along with attempting to schedule it when the
user/transaction activity is at is lowest point. You may end up doing more
than one export.
As for the different rollback...probably other sessions are using other rollbacks and before the export can get to a read consistent view of a table into it's assigned rollback the transactions from other sessions has already been overwritten. (guesstimation)
Brad O.
-----Original Message-----
Sent: Thursday, May 08, 2003 4:02 AM
To: Multiple recipients of list ORACLE-L
Dear All,
In the past I had problem taking a consistent export from a very active database. At that time I had ORA-1555 error.
I though if I created a big rollback and force the export use it I would resolve the problem.
Thus I created an after logon schema trigger on the user I was specifying on the export command .
I have tested it and for a number of days thinks were going as expected.
Yesterday the export failed with ORA-1555 again but on different rollback than the one I have set in the after logon trigger.
May someone of you explain this?
Kind Regards,
Hatzistavrou Yannis
Database Administrator
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: Brad.Odland_at_qtiworld.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 08 2003 - 08:31:41 CDT
 |
 |