Skip to content
August 11, 2011 / doganay

NON-LOCAL PARTITIONED INDEXES

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

 

Hi,

 

If you are creating index on a partitioned table, often advice is that: your index should be local, not global.

so you can create that index:

 

create index myindex

on mytable

(

myfield1 asc,

myfield 2 asc

)

local

online;

 

* Note that unique indexes on partitioned tables (of course, including PK) can not be local partitioned.

 

 

Well, you may want to query those indexes, which are created on partitioned tables and not local:

 

select index_name from dba_indexes where uniqueness<>'UNIQUE'
and table_name in
(
 select table_name from dba_tab_partitions
)
minus
select index_name from dba_ind_partitions;

try and pray :)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: