| Drop tablespace issue [message #357052] |
Mon, 03 November 2008 12:57  |
monto
Messages: 60
Registered: November 2007
Location: DALLAS
|
Member |
|
|
Hi Gurus,
I am trying to drop tablespace which has LOB segments(couple of them) in it,before dropping the tablespace i did an offline drop for the datafiles attached to that tablespace before actually checking if there are any segments remaing it,and db is running in noarchivelog mode,when i am trying to move it or even trying to drop the lob segments with this tablespace getting the below error.
ORA-00376: file 26 cannot be read at this time
ORA-01110: data file 26: '/u05/oradata/XX/XX01_data07'
i can't bring it online as db is running in noarchivelog so my question is ,is it possible to forcefully drop tablespace so that i can reclaim some space.
Thanks
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
