Re: oracle create index

"John" <nihal_at_newmexico.com> wrote in message news:bfif80$87m$1_at_reader2.nmix.net...
> Ouch, I was worried this would be the answer. I have a script written that
> could easily build all the indexes with the table name concatinated on the
> front or something of the like, however what I am trying to avoid is
> rewriting all the other software that makes queries using these index names.
>
> If I build each table and indexes into it's own schema, will this solve my
> problem and will this create other problems?
>
> Thanks for the help.
>

If you build each table and indexes into its own schema, it will solve your problem BUT it will create so many other problems that you wouldn't even wanna think about doing it this way.

What kind of software is this which makes queries using index names? That does not seem right.
Do you mean that you have named primary key constraints etc in a certain way and the software makes queries using the names.
Well then you should and would have to rewrite that piece of software. There isn't really any other way.

hth

Anurag Received on Mon Jul 21 2003 - 23:44:08 CDT