Skip to content
January 15, 2013 / doganay

HOW TO FIND NON-LOCAL INDEXES ON PARTITIONED TABLES

select i.owner,i.index_name from dba_indexes i, dba_part_tables p
where i.table_name=p.table_name and i.owner not in
(
'CTXSYS',
'DBSNMP',
'EXFSYS',
'FLOWS_030000',
'FLOWS_FILES',
'MDSYS',
'OLAPSYS',
'ORDSYS',
'OUTLN',
'SCOTT',
'SYS',
'SYSMAN',
'SYSTEM',
'TSMSYS',
'WK_TEST',
'WKSYS',
'WMSYS',
'XDB'
)
minus
select owner,index_name from dba_part_indexes;
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: