Is it at all possible to drop partitioned index from just one of the partition?
I have recently did a partition swap - but I can't seem to rebuild the partitioned index onto the new tablespace. Rather than dropping the index across all partitions, I wanted to know if it can be done locally.
That's what I'm trying to bloody find out. Well done to YOU for being able to do what I can't on YOUR database, but unfortunately, it doesn’t on mine and the reason behind that is what I'm trying to find out.
I know the syntax on how to rebuild partitioned index. I tried it. It didn't work. I want to find out why. I was under impression I could get some advice and help from those with more knowledge, but instead all I get is mocked.
You won’t mind if I don't thank you for making me feel patronised and ridiculed in public forum.