You should be able to add additional tablespace without any problems. I'm not sure if you need to bring the database down to do it, though. One thing you might consider looking at, though, is whether your CLOB columns are being stored in-row or out-of-row (you didn't indicate which version of Remedy you are using, but this should apply to at least 7.0 and beyond). There is a whitepaper about the issue and how to change it. The whitepaper is available from BMC's website with the other documentation.
Depending on your data, switching the CLOBs from out-of-row to in-row can significantly reduce the space used by your database and improve response times as well. When we made the change on our production database, our space usages when from about 190GB down to about 12GB. That's more than a 90% reduction in space. Your mileage may vary. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of lakhes Sent: Thursday, April 01, 2010 7:45 AM To: [email protected] Subject: Oracle table space issue ** Hi Listners, I need assistance on follwoing issue. We found out that our Oracle 10 is running out of 32g table space. Is it going to cause any major problem? Can we add 1G Table space? Has anyonedone this before can advise us if is it going to cause any major problems? The other option suggested was reindexing so which option one should we go for? What typical procedure to do the option? Do we have to bring remedy services down? Thanks _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
