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: [email protected]
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:[email protected]] On Behalf Of Misi Mladoniczky
Sent: 27 February 2012 17:33
To: [email protected]
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"
