Hi all, Thanks for the information.
I ask this because our support refuse future support if we change this value..... Best Regards Konstantin Pavlov -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, October 30, 2007 5:16 PM To: [email protected] Subject: Re: Database issue I found this insightful: http://tkyte.blogspot.com/2007/02/i-learn-something-new-every-day.html Axton Grams On Oct 30, 2007 10:48 AM, Davies, J.T. <[EMAIL PROTECTED]> wrote: > We went through this exact change about two months ago. Our 60gig DB > went down to 13gig overnight after my DBA's rebuilt the tables with this > parameter. I can't see a reason why you wouldn't use this on an Oracle > database...(but then, I'm still pretty green to Oracle.) > > J.T. > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Axton > Sent: Tuesday, October 30, 2007 7:00 AM > To: [email protected] > Subject: Re: Database issue > > This should not be a problem. Remedy simply alters the ddl for the > create table statements when that parameter is changed. The effects on > the dml (select, insert, update) should not be impacted by alterations > made by your dba. Just make sure Remedy is down when your dba's are > making the changes. > > Axton Grams > > On Oct 30, 2007 6:50 AM, Konstantin Pavlov <[EMAIL PROTECTED]> > wrote: > > ** > > > > > > > > Hello all, > > > > > > > > Remedy 7.0.01 patch 004 > > > > Server Group > > > > > > > > DB:10.2.0.2.0 64bit > > > > > > > > > > > > We have this issue: > > > > > > > > We need to change our default value of DB parameter "create storage in > > > row", because our db is 64GB > > > > and we want to reduce size of it. > > > > > > > > "storage in row" clause is described in > > http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10840/mm_dba. > > htm > > > > > > > > > > > > Before some months we change it from remedy admin tool -> Server > > Information > > -> Database -> Store Clob in Row, > > > > but this is available only for new created forms and with clob for > > storing of data - like HPD HelpDerk. > > > > > > > > > > > > My question is: > > > > > > > > If we change this parameter to True for existing tables (directly in > > db) and our db admins recreate tables > > > > (export and import data) should this cause future problems for our > > prod Remedy data and/or db? > > > > > > > > > > > > Best Regards > > > > > > > > Konstantin Pavlov > > > > __20060125_______________________This posting was submitted with > > HTML in it___ > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
