tag:blogger.com,1999:blog-20612393.post406881146313651081..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: ORA-00959: tablespace '_$deleted$16$0' does not existSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-20612393.post-26989172830912039242010-11-22T08:10:08.633+07:002010-11-22T08:10:08.633+07:00Hi Surachart,
I like that. So you can alter delet...Hi Surachart, <br />I like that. So you can alter deleted indexes in the recycle bin, just like any other index, thats interesting. I guess this shows that Oracle simply flags the index as deleted so a query wont use it, but truly does nothing more than that and of course the name change when the recycle bin is available. No wonder they are easy to recover from.<br /><br />PeterPeter McLartyhttp://blog.pameacs.comnoreply@blogger.com