-
We have an Oracle Instance in which all the rollback segments are part of a tablespace that has one datafile.
Unfortunately, the datafile is corrupted. we dropped the datafile using 'alter database datafile 'sdsd' offline drop; ' which got corrupted. deleted the datafile restarted the database. when we try create the new tablespace, it gives an error ora-376 cannot read at this time.
when we try to drop the rollback segment tablespace using the command drop tablespace rollback_data including contents. it gives an error message. it contains active rollback segments. the status of the rollback segments are needs recovery.
we want to drop the tablespace recreate the tablespace and rollbacksegments. how do we go about doing this ?
R.John Dhinakaran
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
|