Try changing a character field from < 4000 characters to > 4000 characters (or unlimited)
This should change it from a VARCHAR2 to a CLOB and I think that will cause ARS to do the create new table, copy the data, and rename the tables operation. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton Sent: Monday, February 27, 2012 12:04 PM To: [email protected] Subject: Re: Remedy Table Recreation Thanks Misi. I'm trying to identify a specific case on Oracle. I don't think this exists any more (as it used to), but I need to try and confirm. Hoping I get lucky and find someone who has run into this. Axton Grams -----Original Message----- On Mon, Feb 27, 2012 at 11:32 AM, Misi Mladoniczky <[email protected]> wrote: > 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"
