Database DataWarehousing (MOSC)

MOSC Banner

atler primary_key global indexes to include partitions

edited May 4, 2010 4:50AM in Database DataWarehousing (MOSC) 5 commentsAnswered
I have a db with tables and indexes that are partitioned out to 87 partitions. all indexes are partitioned except the _pk indexed are global indexes. I have been researching to find out how to partition primary key indexes but cant find anything.

does anyone know:

1. if a _pk index can be altered to include partitions

2. what the syntax is to do this

thanks 

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