I know some of the Alter commands are Implicit commits.. so I think the data is ok..
On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi <[email protected]> wrote: > 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 > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
