Home » RDBMS Server » Server Administration » deleting a datafile of Rollback segment
deleting a datafile of Rollback segment [message #55656] Thu, 06 February 2003 13:12 Go to next message
KK
Messages: 24
Registered: March 2002
Junior Member
hi all,

how to drop a datafile of a Rollback segment tablespace.
I have actually created more no.of files for a re-organization purpose.Now i want to delete them.
Can anyone tell me about this.

Regards
KK

Report message to a moderator

Re: deleting a datafile of Rollback segment [message #55658 is a reply to message #55656] Thu, 06 February 2003 14:38 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
RBS does not have any data.
so, make the rbs offline normal.
drop the whole tablespace and recreate it.
i beleive, you cannot drop a single datafile from a tablespace.

Report message to a moderator

Previous Topic: Re: trace location
Next Topic: x$ tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:22:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.