Errors during Export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Errors during Export

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    I am getting the following error while doing a full database export.

    EXP-00056: ORACLE error 1555 encountered
    ORA-01555: snapshot too old: rollback segment number 4 with name "CTXROL" too small

    I do this export every day and I dont want to increase the size of all my rollback segments.

    Is there a way where i can specify the rollback to be used by export.

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ORA 1555 is indicitive of rbs that are too small. You are probably using consistent=y which exaggerates this condition on an export.

    Your two options are to increase the size of your RBS, or don't use consistent=Y.

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Yes, I am using consistent=y and my rollback segments are initial=next=1M, minextents=10 and optimal = 20

    Is it the export which generates the rollback or the transactions on the database during export which is causing this.

    My knowledge tells me that its the transactions executed during the export with consistent=y which is causing this.

    This also means that we cannot specify which rollback segment to use because we are not aware of which transactions are going to run.

    Please confirm.

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The export is not generating any rollback. The ORA 1555 error is thrown because the export program can not get a consistent view of the data because of the transactions that are being executed after the export started.

    Obviously, your rollback segments can't hold enough data for you to do this export. They need to be resized.

    You can not specify an RBS for export to use (easily, anyway).
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Apr 2002
    Posts
    55
    If we knew what it was we were doing, it would not be called research, would it ?

    VenDe ChukPeen Zuri

    Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width