---
title: "查询数据库分区表中非分区的索引。"
author: "hotjava"
date: "2008-05-06T20:12:37Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-05-06T20:12:37Z"
id: 190368
url: "https://hotjava.iteye.com/blog/190368"
---

select

dba\_tables.table\_name,  
dba\_indexes.index\_name,  
dba\_indexes.index\_type,  
dba\_indexes.partitioned,  
dba\_indexes.uniqueness

 

 from dba\_tables, dba\_indexes  
where 1 = 1  
and dba\_tables.owner = dba\_indexes.owner  
and dba\_tables.table\_name = dba\_indexes.table\_name

and dba\_tables.owner = 'RMS'  
and dba\_tables.partitioned = 'YES'  
and dba\_indexes.partitioned = 'NO'  
and dba\_indexes.uniqueness = 'NONUNIQUE'