Re: SYS_C* indexes

These are unnamed primary and/or unique key constraints for which Oracle generated a name.
So your developers did create them and in an improper way. If you import those constraints in an empty database, you may end up with different index names.
You should be able to find the indexes in dba_constraints, giving you a clue as to where they belong.

Hth,

--
Sybrand Bakker, Oracle DBA
Liz Reen <Liz_at_reading.news> wrote in message news:MPG.12f0ed5daed099a2989745_at_news.supernews.com...
> A whole pile of indexes named SYS_C####### (where ###### is a number) are
> appearing in user schema's. I know that this naming convention is not
unusual in the
> system schema. Oracle support claims that these are not created by
Oracle. However none
> of my developers created these indexes. Both instances showing these
indexes have had
> a lot of import/exports. Could they have been created during the import?
I don't wish
> to support a pile of write only indexes. Can anyone give me a clue as to
what is
> happening?
>
> Liz
>
> --
> My real address is L I Z R a t A O L d o t C O M
Received on Thu Jan 20 2000 - 09:19:14 CST