Actually,, this is what I was wondering... so do I run the whole job again, or is there some way to run this somehow that I know it will finish..
I thought about running this from an escalation, then I thought better.. an escalation thread running for 3 days.. this is probably a bad idea... ROFL.. On Tue, Mar 13, 2012 at 11:35 AM, Axton <[email protected]> wrote: > 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 <[email protected]> > wrote: > > ** That is what I want.. > > > > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky <[email protected]> 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 <[email protected]> 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" > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
