Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question: cleaning up PK indexes
Thanks for the pointer; here's what I came up with:
select constraint_name from sys.all_constraints where constraint_name like 'PK_%' and constraint_name not in (select index_name from sys.all_indexes)
Seems to give me what I'm looking for...
Cheers,
DW Received on Fri Apr 29 2005 - 17:25:47 CDT