Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: stange rollback behavior

RE: stange rollback behavior

From: Odland, Brad <>
Date: Thu, 08 May 2003 05:31:41 -0800
Message-ID: <>

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:

Author: Odland, Brad

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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

Original text of this message