If that is all that was found, and T374 is the Help Desk form, then I
would try and add them back. Index on C1 is done when a form is
created. The H and B tables get a simaliar index.
Did you run the check on your dev server or the prod server? Would be
curious to see what your prod server looks like.
On Tue, Mar 18, 2008 at 8:53 PM, Steven Pataray <[EMAIL PROTECTED]> wrote:
> **
> My dba had me do the following query to check which I entered T374 as the
> parameter and it only resulted one record.
> > IT374 UNIQUE C1 1
>
>
> SELECT IND.INDEX_NAME,
> IND.UNIQUENESS,
> COL.COLUMN_NAME,
> COL.COLUMN_POSITION
> FROM SYS.USER_INDEXES IND,
> SYS.USER_IND_COLUMNS COL
> WHERE IND.TABLE_NAME = upper('&&table')
> AND IND.TABLE_NAME = COL.TABLE_NAME
> AND IND.INDEX_NAME = COL.INDEX_NAME;
>
> If I have my DBA set the indexes instead will this cause any problems? Would
> he also have to update the B374 and H374 tables?
>
> Thanks
> Steve
>
>
>
> On 3/18/08, Frank Caruso <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > By any chance are there indexed on that form (table) in the database
> > that are not being shown to you in the Admin tool? Did someone create
> > indexed directly in the database?
> >
> > On Tue, Mar 18, 2008 at 4:42 PM, Steven Pataray <[EMAIL PROTECTED]>
> wrote:
> > > **
> > >
> > > I've never tried indexing before. What is the proper proceedure to index
> > > fields from the Admin tool? OTB the Category/Type/Item fields are
> indexed. I
> > > want to remove those and add the Requester Login Name+, Department,
> Create
> > > Time and Status fields. But when I save I get errors:
> > >
> > >
> > > Failure during SQL operation to the database : ORA-01418: specified
> index
> > > does not exist (ARERR 552).
> > > Failure during SQL operation to the database : ORA-01418: specified
> index
> > > does not exist (ARERR 552).
> > > Failure during SQL operation to the database : ORA-01418: specified
> index
> > > does not exist (ARERR 552).
> > > A duplicate index has been specified --
> > > duplicate was omitted and indexes were created : 240000005 (ARERR 74).
> > >
> > > Then it says the form was not saved. When I try to first remove the
> Category
> > > field from the index I get:
> > >
> > > Total length of all fields involved in an index is greater than the
> maximum
> > > length allowed (ARERR 210).
> > > A duplicate index has been specified --
> > > duplicate was omitted and indexes were created : 240000005 (ARERR 74).
> > > A duplicate index has been specified --
> > > duplicate was omitted and indexes were created : 200000003 (ARERR 74).
> > >
> > > But then the Category field is removed from the index tab when I open
> the
> > > form back up. What is this telling me?
> > >
> > > I did this on my dev server Arsystem 6.3 patch 019 pending to do it on
> my
> > > 6.3 patch 023
> > > Oracle 10.1.0.4.0
> > > HelpDesk 6.3
> > >
> > > Thanks,
> > >
> > > Steve
> > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > > html___
> >
> >
> _______________________________________________________________________________
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> >
> > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> >
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
