Re: SYS_C* indexes

Sybrand Bakker wrote:

> 
> 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

If at all possible, I'd also suggest that the constraint be dropped and then re-created with a meaningful name. Sometimes this is a tremendous job if there are a lot of them and the effort can be staggering. However, it will ultimately make the schema easier to understand.

Why Oracle would claim that they are not created by Oracle is incomprehensible.

..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
Received on Thu Jan 20 2000 - 11:41:07 CST