You may run into timeouts if a table is locked for a long enough period of time and workflow, or a user, try to update a record in that table. The same problems that apply to oracle errors in general apply to this scenario.
Axton Grams On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi <remedy...@gmail.com> wrote: > ** That is what I want.. > > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky <m...@rrr.se> wrote: >> >> Hi, >> >> You should see a significant size reduction as well as performance >> improvement on inserts/updates :-) >> >> The size was reduced to less than half in the system I was working on, and >> the bulk of the data left was actually attachments. >> >> 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. >> >> > I think I have around 120 Gig of LOB, that is going from out to in.. >> > I need to put in row, it is getting out of control.. >> > >> > On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky <m...@rrr.se> wrote: >> > >> >> Hi, >> >> >> >> I have done that a couple of times without any real problems. It did >> >> take >> >> a lot less than 24 hours though, so these systems were probably much >> >> smaller. About 10-15GB if I remember right, and much bigger with >> >> out-row >> >> storage. >> >> >> >> 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. >> >> >> >> > Hey all , >> >> > Odd question, from a person who is not normal.. which is normal.. lol >> >> > >> >> > If you have a production system and you are taking an existing system >> >> that >> >> > is up and running online >> >> > and you do the modify all the lob's from out-row to in-row >> >> > is there any issues with doing this while everyone is using it ? >> >> > >> >> > I see nothing obviously stated that you should not run this while >> >> doing >> >> > audits, or anything.. >> >> > Does Oracle take care of that scenario, while moving from one way to >> >> the >> >> > other.. >> >> > >> >> > I did one system that took almost 24 hours.. This is why I am >> >> asking... >> >> > >> >> > thanks.. >> >> > >> >> > -- >> >> > Patrick Zandi >> >> > >> >> > >> >> >> >> _______________________________________________________________________________ >> >> > 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" >> >> >> > >> > >> > >> > -- >> > Patrick Zandi >> > >> > >> > _______________________________________________________________________________ >> > 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" > > > > > -- > Patrick Zandi > _attend WWRUG12 www.wwrug.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"