Partition an unpartitioned primary key index to become locally partitioned by primary key

indexoraclepartitioning

I tried:

alter index clave_primaria_de_b local;

and I read:

ALTER INDEX

But I don't know how to do it.

Best Answer

You cannot convert a global index into a local index with an ALTER INDEX command. You need to drop the index and recreate it using the LOCAL keyword.