-
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;
Best wishes!
Dmitri
-
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.
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
|