Hi David, Yes, at a database level is another option and access is "available" to me ;o)
Presumably then, its just a quick visit to the admin tool to remove the form then afterwards and any workflow ??? rgds, Sean ________________________________ From: David Morgan <[email protected]> To: [email protected] Sent: Thu, 19 November, 2009 15:14:50 Subject: Re: Deleting a form with 2 million records Hi Sean Is it possible to access it via the database and use :- truncate table Txxx ; truncate table Bxxx ; truncate table Hxxx ; where xxx is the schemaid of the table (select name, schemaid from arschema where name = 'FORM NAME';) so as to empty the records therein, before deleting the form? That's probably the quickest way. Regards Dave Morgan -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tommy Morris Sent: 19 November 2009 15:09 To: [email protected] Subject: Re: Deleting a form with 2 million records This is a multi-part message in MIME format. ------_=_NextPart_001_01CA692A.3580FDC6 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I would write a nice script that deleted the records in blocks of say 50-100k and run it at night. You could test it with a block of 100 during operating hours just to get an idea of the overhead then up to 1k if things looked good there for another baseline. But then again it depends on the size of the record too, is there only 10 columns on the field or 100? Purging 1000 records with 1kb of data will go a lot smoother than purging 1000 records with 50kb of data. =20 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sean Harrodine Sent: Thursday, November 19, 2009 8:58 AM To: [email protected] Subject: Deleting a form with 2 million records =20 **=20 Hi all, =20 I need to delete a form and the 2 million records stored in it. =20 Can anyone elighten me please as to the best and safest way to delete the table with the least amount of impact on the system ie, without spiking the Oracle archive logs. =20 Is it best to remove some or most of the records by using an ARSPerl "DeleteEntry" script first, before blowing the form away in the Admin tool, or is there another way that that i'm not savvy too ? =20 TIA, Sean =20 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" ------_=_NextPart_001_01CA692A.3580FDC6 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:x=3D"urn:schemas-microsoft-com:office:excel" = xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" = xmlns:a=3D"urn:schemas-microsoft-com:office:access" = xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" = xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" = xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" = xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" = xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" = xmlns:c=3D"urn:schemas-microsoft-com:office:component:spreadsheet" = xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" = xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" = xmlns:html=3D"http://www.w3.org/TR/REC-html40" = xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" = xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" = xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" = xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" = xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml" = xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" = xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" = xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/" = xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" = xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" = xmlns:udc=3D"http://schemas.microsoft.com/data/udc" = xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" = xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/ "= xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" = xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" = xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" = xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" = xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" = xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" = xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart" = xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/" = xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsig-setup" = xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsig" = xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/2006/digital-si g= nature" = xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/200 6= " xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relationsh i= ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" = xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types "= = xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messa g= es" = xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary /= " = xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPortalServer/Pu b= lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" = xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)"> <style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D'>I would write a nice script that deleted the records in = blocks of say 50-100k and run it at night. You could test it with a block of = 100 during operating hours just to get an idea of the overhead then up to 1k = if things looked good there for another baseline. But then again it depends = on the size of the record too, is there only 10 columns on the field or 100? = Purging 1000 records with 1kb of data will go a lot smoother than purging 1000 = records with 50kb of data.<o:p></o:p></span></p> <p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D'><o:p> </o:p></span></p> <div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt = 0in 0in 0in'> <p class=3DMsoNormal><b><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span >= </b><span style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Action = Request System discussion list(ARSList) [mailto:[email protected]] <b>On = Behalf Of </b>Sean Harrodine<br> <b>Sent:</b> Thursday, November 19, 2009 8:58 AM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> Deleting a form with 2 million = records<o:p></o:p></span></p> </div> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>** <o:p></o:p></p> <div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Hi all,<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'> <o:p></ o= :p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>I need to delete a form and the 2 million records stored in = it.<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'> <o:p></ o= :p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Can anyone elighten me please as to the best and safest way to delete the = table with the least amount of impact on the system ie, without spiking the = Oracle archive logs.<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'> <o:p></ o= :p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Is it best to remove some or most of the records by using an ARSPerl "DeleteEntry" script first, before blowing the form away in = the Admin tool, or is there another way that that i'm not savvy too = ?<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'> <o:p></ o= :p></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>TIA,<o:p></o: p= ></span></p> </div> <div> <p class=3DMsoNormal><span = style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Sean<o:p></o: p= ></span></p> </div> </div> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>_Platinum Sponsor: [email protected] = ARSlist: "Where the Answers Are"_<o:p></o:p></p> </div> </body> </html> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ------_=_NextPart_001_01CA692A.3580FDC6-- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

