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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
