DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Rollback Segment Datafile

  1. 03-21-2003, 01:51 AM #1
    vijay8282
    vijay8282 is offline Senior Member
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Rollback Segment Datafile

    Hi,

    I am getting ora-01555 error while doing an import. I cannot use any parameters like commit=Y etc with my Import as this is automated import in SAP.

    I want to add more datafiles in ROLLBACK tablespace. But after I finish, I hv to get rid of those also. I already hv rollback datafiles of size 8 GB. (4 files)

    What can be done to carry out my activity successfully.

    Regards
    Vijay
    --------------------------
    The Time has come ....
    Reply With Quote Reply With Quote
  2. 03-21-2003, 01:54 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Instead of adding datafiles to RBS tablespace try creting few more rollback segments. I assuming that you are not on 9i and not using AUM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  3. 03-21-2003, 01:56 AM #3
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    1. Create a new tablespace.
    2. Create 3 to 4 monster rollback segments of size 1GB (or what ever you think is enough to hold your transaction) each.
    3. Put other smaller rollback segments offline before the import.
    4. Import.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  4. 03-21-2003, 01:57 AM #4
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by SANJAY_G
    Instead of adding datafiles to RBS tablespace try creting few more rollback segments. I assuming that you are not on 9i and not using AUM.
    More rollback segments or bigger rollback segments?? I think transactions can not span across rollback segments.
    -nagarjuna
    Reply With Quote Reply With Quote
  5. 03-21-2003, 02:10 AM #5
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Of course transaction cannot span across rollback segment. Here BIGGER and MORE, both will help but none will guarantee to avoid ORA-01555. AUM does it more efficiently.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  6. 03-21-2003, 02:20 AM #6
    vijay8282
    vijay8282 is offline Senior Member
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Hi

    Hi,

    I again got the error and after seeing it closely it says max extents reached. I m now going to resize my extents from ini 10M, next 10M to 20M.

    Regards
    Vijay
    --------------------------
    The Time has come ....
    Reply With Quote Reply With Quote
  7. 03-21-2003, 02:21 AM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Hi

    Originally posted by vijay8282
    Hi,

    I again got the error and after seeing it closely it says max extents reached. I m now going to resize my extents from ini 10M, next 10M to 20M.

    Regards
    Vijay
    Increase the max extents.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  8. 03-21-2003, 03:15 AM #8
    pnrdba
    pnrdba is offline Senior Member
    Join Date
    Apr 2002
    Posts
    291
    Can you shrink after your import is done successfully?? Why can't we use optimal values here for such rollback segments?
    Many gurus .. to correct me if i'm wrong

    Thanks....
    PNRDBA
    Reply With Quote Reply With Quote
  9. 03-22-2003, 05:31 AM #9
    vijay8282
    vijay8282 is offline Senior Member
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    Thatz what i wanna know. but from replies it looks we can't shring. optimal is ok, segment shrinks back to that level. but th datafile cannot be shrinked as the HWM is on the higher side.

    This time i didn't faced maxextents eror, but space has finished in the files.

    i m gonna add more space to rollback segs.


    Regards
    Vijay
    --------------------------
    The Time has come ....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width