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"
