Have you checked the Database Reference Guide for your version? There's a section in there that details when/how the tables are modified.
Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton Sent: 27 February 2012 18:20 To: [email protected] Subject: Re: Remedy Table Recreation Close. It creates a temp column and not a temp table: ALTER TABLE T3185 ADD (C536870916Z clob NULL) ALTER TABLE T3185 DROP COLUMN C536870916 ALTER TABLE T3185 RENAME COLUMN C536870916Z TO C536870916 DROP VIEW ztestsql1 CREATE VIEW ztestsql1 (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date,Status,Short_Description,Date_Time_Field,Character_Field) AS SELECT T3185.C1,C2,C3,C4,C5,C6,C7,C8,C536870913,C536870916 FROM T3185 DROP VIEW SH_ztestsql1 CREATE VIEW SH_ztestsql1 (Request_ID,New_TIME,New_USER,Assigned_TIME,Assigned_USER,Fixed_TIME,Fixed_USER,Rejected_TIME,Rejected_USER,Closed_TIME,Closed_USER) AS SELECT entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4 FROM H3185 On Mon, Feb 27, 2012 at 12:10 PM, Grooms, Frederick W <[email protected]> wrote: > 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" _______________________________________________________________________________ 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"
