I seem to remember years ago that databases would drop a table and rebuild it if you deleted a field but I understand that modern databases don't need to do this.
Misi, adding or deleting a CMDB attribute will cause fields to be added to and deleted from tables. Out-of-the-box you'd need admin permissions to do this but a customer could have mapped the CMDB roles to non-admin staff. Cheers Peter -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: 27 February 2012 17:33 To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation Hi, It depends on the database, where different vendors allow for different changes with ALTER TABLE. I think that if you go to/from 255 bytes in character lenght, this requires a datatype change from VARCHAR to TEXT, which will trigger the operation. For all practical purposes, it should be impossible for a person using the normal user clients to cause this. You would also need to have Admin or Sub Admin permissions to do anything like that. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > First, some background information: > It used to be the case that certain operations would trigger Remedy to > recreate a database table: > - rename existing table > - create new table with the original name > - copy the data from the renamed table to the new table > - drop the renamed table > > I remember altering the precision on a decimal field would trigger > this, and I seem to also remember something with currency fields. > > Now for the issue: > We have applied changes to every table in the Remedy database to > define a primary key. This primary key is used for Oracle Streams > replication to a target database. If the table is recreated, the > primary key is dropped, which can cause Streams to choke if the table > contains a large volume of data. > > Now for the question: > Does anyone know of an action that a user can perform through the > Remedy clients that will cause a table to be recreated in this manner? > When I say "Remedy Clients" I am referring to Dev Studio, User Tool, > ITSM applications, mid-tier, or the Remedy API. > > Relevant Environment Information: > - Oracle 11g > - ARServer 7.5 > - Apps 7.5 (ITSM, CMDB, etc.) > > Thanks, > Axton Grams > > ______________________________________________________________________ > _________ 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
