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

Thread: How to drop a datafile containing rollback segments

  1. #1
    Join Date
    Dec 2000
    Posts
    22

    Arrow

    Hi,

    We have an Oracle Instance in which all the rollback segments
    are part of a tablespace that has one datafile.

    Unfortunately, the datafile is corrupted. (We ran dbv to verify
    that it is corrupted). The SYSTEM rollback segment is fine.

    What is the right and easiest way of fixing this problem?

    Thanks,
    - Hari

  2. #2
    Join Date
    Jun 2000
    Posts
    179

    Talking

    - Create new tablespace with datafile in it
    - create new rollbacks in it
    - Alter new rollbacks online
    - alter old rollbacks offline
    - drop old rollbacks
    - drop corrupted datafile & tablespace
    - Manipultae init.ora file for the instance and include an entry to activate new rollbacks automatically whenever instance is initialized like :
    rollback_segments=(hh,hh,hh,hh)
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Dec 2000
    Posts
    22
    Nagia,

    Thanks for your help.

    - Hari

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