Re: Delete a datafile from a tablespace

Anthony Hogan wrote:

> I'm not sure if this will work if the database is in archivelog mode. I
> tried this (8.1.7 archivelog):

Yep. That is what I said "offline/drop" as in maybe drop will not be possible. Life is a bitch isn't it. And in case you wondering why I reveling at your problem is 'cause it just friggen great to see others also having problem besides me... <evil & twisted grin> ;-)

> I may be missing something but then again I'M still on my first cup of
> coffee :)

Shrink it. So you will have a useless 1KB datafile in the database. Cover your ass by renaming it to something like '../oracle_system_buffer_zone_19.dbf' or something equally impressively meaningless to obfuscate the clueless. :-)

Hey, at least this problem is better than the junior DBA some years ago who was suppose to add more space for me and forgot to add the M at the back of size.. giving me 2K of a raw device instead of 2GB.. Not that was a horror to fix.

--
Billy