Sorry, there is an index on C1 on the T table, as you would expect, but no others.
Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson <n...@ncsu.edu> wrote: > Hi Fred, > > Nope, it is the other way around.... Dev Studio says there are indexes, but > there are none on the T table nor entries in the SCHEMA_INDEX table. > > Thanks. > Larry > > On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W < > frederick.w.gro...@xo.com> wrote: > >> So there are indexes on the T table, but no record of them in >> SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. >> >> Have you tried restarting the app (as the index info is held in memory >> while the server is running) >> >> Fred >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] On Behalf Of L G Robinson >> Sent: Tuesday, October 25, 2011 12:49 PM >> To: arslist@ARSLIST.ORG >> Subject: Indexes that aren't really there >> >> ** >> Hi Folks, >> >> My AR System is confused about the indexes on a particular form. The AR >> System believes that there are four indexes on this particular form but in >> the database (Oracle) there are no entries for this form in the SCHEMA_INDEX >> table. When I attempt to delete the indexes using Dev Studio, I get errors: >> >> Failure during SQL operation to the database : ORA-01418: specified >> index does not exist, 552, AR System User Central File >> >> and I can see from the SQL logs: >> >> */*** ERROR *** ORA-01418: specified index does not exist >> >> So it appears that there is some other place within the AR System that >> still indicates that there are indexes on this form. Can anyone tell me >> where to look? >> >> I understand the dangers of mucking around directly in the database >> tables. This is my development system, so the results of a mistake will not >> be catastrophic. >> >> Thanks. >> Larry >> >> ARS: 7.6.03 - Solaris 10 >> Oracle: 11.2.0.1.0 - 64bit >> >> Larry Robinson >> NC State University >> Remedy Admin/Developer >> 919-515-5432 >> n...@ncsu.edu >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
