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
Printable View
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
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;
Hello
I hope you understand the meaning of "Alter database datafile 'name.dfb' offline drop ."
regards
Hrishy
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.