Drop datafile in tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Drop datafile in tablespace

  1. #1
    Join Date
    Jan 2002
    Posts
    48

    Question

    Hi !

    I have a rollback tablespace with two (2) datafiles. How can I remove one of the datafiles ? Oracle version 8.0.6.

    Regards Mattias

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Take your rollback segs offline.
    If you are running in noarchive log mode you have only one way:
    Alter database datafile 'name.dfb' offline drop;
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hello

    I hope you understand the meaning of "Alter database datafile 'name.dfb' offline drop ."

    regards
    Hrishy

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot remove a datafile from a tablespace

  5. #5
    Join Date
    Jan 2002
    Posts
    48
    I understand that Alter database datafile 'name.dfb' offline drop will not remove the rbs internally from the database and still let information live in data dictionary. Therefore and by some other reasons I dont want to use this solution. Probably I will have to recreate my rollback tablespace from scratch ? I also heard like pando points out that one cannot remove a datafile from a tablespace, only shrink it or maybe offline drop it.

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