I read that thread, but the terminology confused me. Just to be clear on the terminology; I am looking for things that issue a DROP TABLE and a CREATE TABLE (in an effort to alter the characteristics of an existing table) and I am not concerned with things that issue an ALTER TABLE.
Thanks, Axton Grams On Mon, Feb 27, 2012 at 10:33 AM, LJ LongWing <lj.longw...@gmail.com> wrote: > Axton, > Based on recent conversations with Doug....shrinking the size of a Char > field will NOT cause a recreation of the table...but a re-increase, of a > size below the size allowed with the previous size, will...for example > > Original size: 255 > New Size1: 49 > New Size2: 50 > New Size3: 255 > > You can't resize a field from 255 to 50 without re-building the table...and > the size increase in the second increase WOULD rebuild the table...and again > in resize 3 > > These are the only examples I know of off the top of my head....I'm positive > there are others of course :) > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton > Sent: Monday, February 27, 2012 8:53 AM > To: arslist@ARSLIST.ORG > Subject: Remedy Table Recreation > > 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"
