Using the My Oracle Support Portal (MOSC)

MOSC Banner

How to have Local PK index for a partitioned materialized view

edited May 16, 2018 5:00AM in Using the My Oracle Support Portal (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center