Apparently, the excessive growth can be curbed by setting Remedy to store CLOBS in row (see KB on that). However, once the space has been used by storing them out of row, Oracle won't release the excessive space used. While that's probably not an issue with a demo box, it's something to keep in mind on a production/test box. Rick _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 20, 2007 8:26 AM To: arslist@ARSLIST.ORG Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) ** great, thanks for the feedback Guillaume _____ From: Rick Cook Sent: Wed 06/20/07 10:58 AM To: arslist@ARSLIST.ORG Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) ** Ours, even after all the configuration data was in (including LDAP and a truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing asset records from Discovery, at which time it ballooned to about 10 GB. So even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without FD/TD. Rick _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 20, 2007 7:30 AM To: arslist@ARSLIST.ORG Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) ** great, thanks Jarl. BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample data (excluding the product dictionary) _____ From: Jarl Grøneng Sent: Wed 06/20/07 12:23 AM To: arslist@ARSLIST.ORG Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) Yes, using it on my laptop with 7.x But only for small development tasks... -- Jarl On 6/20/07, Guillaume Rheault <[EMAIL PROTECTED]> wrote: > ** > > Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)? > Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but > maybe somebody has given it a shot... > > XE is free since 02/2006, according to this Oracle press release: > > http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html > > "The software can be downloaded for free from the Oracle Technology Network > at: http://www.oracle.com/technology/xe. Oracle Database XE > is available for download, usage and distribution at no charge." > > Any feedback is appreciated > > thx, Guillaume > > > > > > __20060125_______________________This posting was > submitted with HTML in it___ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"