How to have Local PK index for a partitioned materialized view
Hi,
When you are creating a Materialized View (MV) WITH PRIMARY KEY, you can force the tablespace of the PK index with 'USING INDEX TABLESPACE my_idx_tbs".
Note that the MV PK is automaticallycreated with the MV creation, e.g. on an ID number key.
And you can also have a partitioned MV with the classical "PARTITION ..." syntax, e.g. on a string key.
Then you can add any new index on the just created MV table, using the "LOCAL" syntax to have local index instead of global if the MV is partitioned.
YET seems no way to have the original PK index of my partitioned MV to be also LOCAL