Home » RDBMS Server » Server Administration » Drop tablespace issue (oracle.10204,AIX)
Drop tablespace issue [message #357052] Mon, 03 November 2008 12:57 Go to next message
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
Re: Drop tablespace issue [message #357059 is a reply to message #357052] Mon, 03 November 2008 13:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, put the file offline then you can drop the tablespace.

Regards
Michel
Re: Drop tablespace issue [message #357068 is a reply to message #357059] Mon, 03 November 2008 14:26 Go to previous message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Thanks michel Smile
Previous Topic: Oracle 11g Perl Support ?
Next Topic: too many archive logs
Goto Forum:
  


Current Time: Sun Dec 04 22:50:35 CST 2016

Total time taken to generate the page: 0.12225 seconds