| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS_C* indexes
Kenneth C Stahl wrote:
>
> 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.
>
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
> ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... .....
It normally occurs when you get a newbie on the support line... :-) --
"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 20 2000 - 05:34:40 CST
 |
 |