I don't think it was for Oracle or MS-SQL that Remedy used the table recreate method. It was for one of the other databases and Remedy used the same commands for all (to make cross platform development and support the same everywhere). It may even go back as far as when Remedy used to support flat files as a database.
What matters is that it doesn't appear to be used anymore Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, February 27, 2012 1:28 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation I thought DROP COLUMN always existed since the beginning of times - its just that the AR API didn't use it when it could have in many cases in the earlier days.. But then beginning of times for me was Oracle 7.x and greater and MS-SQL 6.x (6.5 I think) and greater, so am in no position to confirm what I just claimed for anything below those versions.. Joe -----Original Message----- From: Peter Romain Sent: Monday, February 27, 2012 1:21 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation 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" _______________________________________________________________________________ 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"
