I have a rollback tablespace with two (2) datafiles. How can I remove one of the datafiles ? Oracle version 8.0.6.
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;
I hope you understand the meaning of "Alter database datafile 'name.dfb' offline drop ."
you cannot remove a datafile from a tablespace
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.
Click Here to Expand Forum to Full Width