Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

RE: stange rollback behavior

From: Kurth, Michael J. <>
Date: Thu, 08 May 2003 05:27:00 -0800
Message-ID: <>

The only way to force exp to use a rollback segment is to disable all other rollback segments.

-----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

Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter.

The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance.

If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail.

Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it.


Please see the official ORACLE-L FAQ:

Author: Kurth, Michael J.

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:27:00 CDT

Original text of this message