Indeed - once the underlying database tables are "empty" - ala truncate it is
simple to remove the form (and associated indexes/workflow) from the admin tool
- and this will be logged in the redo logs.
STRESS - STRESS - STRESS
BEFORE DOING ANY WORK AT DB LEVEL -
especially destructive work -
MAKE SURE YOU HAVE A DB BACKUP
/STRESS - /STRESS - /STRESS
Regards
Dave Morgan
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Sean Harrodine
Sent: 19 November 2009 15:25
To: [email protected]
Subject: [SPAM] Re: Deleting a form with 2 million records
Yes, at a database level is another option and access is "=
--0-441308472-1258644323=:25356
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi David,=0A=0AYes, at a=A0database level is another option and access is "=
available" to me=A0;o)=0A=0APresumably then, its just a quick visit to the =
admin tool to remove the form then afterwards and any workflow=A0???=0A=0Ar=
gds,=0ASean=0A=0A=0A=0A=0A________________________________=0AFrom: David Mo=
rgan <[email protected]>=0ATo: [email protected]=0asent: Thu, 19 N=
ovember, 2009 15:14:50=0ASubject: Re: Deleting a form with 2 million record=
s=0A=0AHi Sean=0A=0AIs it possible to access it via the database and use :-=
=0A=A0=A0=A0 truncate table Txxx ; =0A=A0=A0=A0 truncate table Bxxx ; =0A=
=A0=A0=A0 truncate table Hxxx ;=0A=0Awhere xxx is the schemaid of the table=
(select name, schemaid from=0Aarschema where name =3D 'FORM NAME';)=0A=0As=
o as to empty the records therein, before deleting the form?=0AThat's proba=
bly the quickest way. =0A=0ARegards=0ADave Morgan=0A=0A=0A-----Original Mes=
sage-----=0AFrom: Action Request System discussion list(ARSList)=0A[mailto:=
[email protected]] On Behalf Of Tommy Morris=0ASent: 19 November 2009 15:=
09=0ATo: [email protected]=0asubject: Re: Deleting a form with 2 million =
records=0A=0AThis is a multi-part message in MIME format.=0A=0A------_=3D_N=
extPart_001_01CA692A.3580FDC6=0AContent-Type: text/plain;=0A=A0=A0=A0 chars=
et=3D"us-ascii"=0AContent-Transfer-Encoding: quoted-printable=0A=0AI would =
write a nice script that deleted the records in blocks of say=0A50-100k and=
run it at night. You could test it with a block of 100=0Aduring operating =
hours just to get an idea of the overhead then up to 1k=0Aif things looked =
good there for another baseline. But then again it=0Adepends on the size of=
the record too, is there only 10 columns on the=0Afield or 100? Purging 10=
00 records with 1kb of data will go a lot=0Asmoother than purging 1000 reco=
rds with 50kb of data.=0A=0A=3D20=0A=0AFrom: Action Request System discussi=
on list(ARSList)=0A[mailto:[email protected]] On Behalf Of Sean Harrodine=
=0ASent: Thursday, November 19, 2009 8:58 AM=0ATo: [email protected]=0asu=
bject: Deleting a form with 2 million records=0A=0A=3D20=0A=0A**=3D20=0A=0A=
Hi all,=0A=0A=3D20=0A=0AI need to delete a form and the 2 million records s=
tored in it.=0A=0A=3D20=0A=0ACan anyone elighten me please as to the best a=
nd safest way to delete=0Athe table with the least amount of impact on the =
system ie, without=0Aspiking the Oracle archive logs.=0A=0A=3D20=0A=0AIs it=
best to remove some or most of the records by using an ARSPerl=0A"DeleteEn=
try" script first, before blowing the form away in the Admin=0Atool, or is =
there another way that that i'm not savvy too ?=0A=0A=3D20=0A=0ATIA,=0A=0AS=
ean=0A=0A=3D20=0A=0A_Platinum Sponsor: [email protected] ARSlist: "W=
here the Answers=0AAre"_=0A=0A=0A__________________________________________=
______________________________=0A_______=0AUNSUBSCRIBE or access ARSlist Ar=
chives at www.arslist.org=0APlatinum Sponsor:[email protected] ARSli=
st: "Where the Answers=0AAre"=0A=0A------_=3D_NextPart_001_01CA692A.3580FDC=
6=0AContent-Type: text/html;=0A=A0=A0=A0 charset=3D"us-ascii"=0AContent-Tra=
nsfer-Encoding: quoted-printable=0A=0A**=0A<html xmlns:v=3D3D"urn:schemas-m=
icrosoft-com:vml" =3D=0Axmlns:o=3D3D"urn:schemas-microsoft-com:office:offic=
e" =3D=0Axmlns:w=3D3D"urn:schemas-microsoft-com:office:word" =3D=0Axmlns:x=
=3D3D"urn:schemas-microsoft-com:office:excel" =3D=0Axmlns:p=3D3D"urn:schema=
s-microsoft-com:office:powerpoint" =3D=0Axmlns:a=3D3D"urn:schemas-microsoft=
-com:office:access" =3D=0Axmlns:dt=3D3D"uuid:C2F41010-65B3-11d1-A29F-00AA00=
C14882" =3D=0Axmlns:s=3D3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =3D=
=0Axmlns:rs=3D3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D3D"#RowsetSche=
ma"=0A=3D=0Axmlns:b=3D3D"urn:schemas-microsoft-com:office:publisher" =3D=0A=
xmlns:ss=3D3D"urn:schemas-microsoft-com:office:spreadsheet" =3D=0Axmlns:c=
=3D3D"urn:schemas-microsoft-com:office:component:spreadsheet" =3D=0Axmlns:o=
dc=3D3D"urn:schemas-microsoft-com:office:odc" =3D=0Axmlns:oa=3D3D"urn:schem=
as-microsoft-com:office:activation" =3D=0Axmlns:html=3D3D"http://www.w3.org=
/TR/REC-html40" =3D=0Axmlns:q=3D3D"http://schemas.xmlsoap.org/soap/envelope=
/" =3D=0Axmlns:rtc=3D3D"http://microsoft.com/officenet/conferencing" =3D=0A=
xmlns:D=3D3D"DAV:" xmlns:Repl=3D3D"http://schemas.microsoft.com/repl/" =3D=
=0Axmlns:mt=3D3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" =
=3D=0Axmlns:x2=3D3D"http://schemas.microsoft.com/office/excel/2003/xml" =3D=
=0Axmlns:ppda=3D3D"http://www.passport.com/NameSpace.xsd" =3D=0Axmlns:ois=
=3D3D"http://schemas.microsoft.com/sharepoint/soap/ois/" =3D=0Axmlns:dir=3D=
3D"http://schemas.microsoft.com/sharepoint/soap/directory/" =3D=0Axmlns:ds=
=3D3D"http://www.w3.org/2000/09/xmldsig#" =3D=0Axmlns:dsp=3D3D"http://schem=
as.microsoft.com/sharepoint/dsp" =3D=0Axmlns:udc=3D3D"http://schemas.micros=
oft.com/data/udc" =3D=0Axmlns:xsd=3D3D"http://www.w3.org/2001/XMLSchema" =
=3D=0Axmlns:sub=3D3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/al=
erts/=0A"=3D=0Axmlns:ec=3D3D"http://www.w3.org/2001/04/xmlenc#" =3D=0Axmlns=
:sp=3D3D"http://schemas.microsoft.com/sharepoint/" =3D=0Axmlns:sps=3D3D"htt=
p://schemas.microsoft.com/sharepoint/soap/" =3D=0Axmlns:xsi=3D3D"http://www=
.w3.org/2001/XMLSchema-instance" =3D=0Axmlns:udcs=3D3D"http://schemas.micro=
soft.com/data/udc/soap" =3D=0Axmlns:udcxf=3D3D"http://schemas.microsoft.com=
/data/udc/xmlfile" =3D=0Axmlns:udcp2p=3D3D"http://schemas.microsoft.com/dat=
a/udc/parttopart" =3D=0Axmlns:wf=3D3D"http://schemas.microsoft.com/sharepoi=
nt/soap/workflow/" =3D=0Axmlns:dsss=3D3D"http://schemas.microsoft.com/offic=
e/2006/digsig-setup" =3D=0Axmlns:dssi=3D3D"http://schemas.microsoft.com/off=
ice/2006/digsig" =3D=0Axmlns:mdssi=3D3D"http://schemas.openxmlformats.org/p=
ackage/2006/digital-si=0Ag=3D=0Anature" =3D=0Axmlns:mver=3D3D"http://schema=
s.openxmlformats.org/markup-compatibility/200=0A6=3D=0A" xmlns:m=3D3D"http:=
//schemas.microsoft.com/office/2004/12/omml" =3D=0Axmlns:mrels=3D3D"http://=
schemas.openxmlformats.org/package/2006/relationsh=0Ai=3D=0Aps" xmlns:spwp=
=3D3D"http://microsoft.com/sharepoint/webpartpages" =3D=0Axmlns:ex12t=3D3D"=
http://schemas.microsoft.com/exchange/services/2006/types=0A"=3D=0A=3D=0Axm=
lns:ex12m=3D3D"http://schemas.microsoft.com/exchange/services/2006/messa=0A=
g=3D=0Aes" =3D=0Axmlns:pptsl=3D3D"http://schemas.microsoft.com/sharepoint/s=
oap/SlideLibrary=0A/=3D=0A" =3D=0Axmlns:spsl=3D3D"http://microsoft.com/webs=
ervices/SharePointPortalServer/Pu=0Ab=3D=0AlishedLinksService" xmlns:Z=3D3D=
"urn:schemas-microsoft-com:" =3D=0Axmlns:st=3D3D"" xmlns=3D3D"http://www.w3=
.org/TR/REC-html40">=0A=0A<head>=0A<meta http-equiv=3D3DContent-Type conten=
t=3D3D"text/html; =3D=0Acharset=3D3Dus-ascii">=0A<meta name=3D3DGenerator c=
ontent=3D3D"Microsoft Word 12 (filtered medium)">=0A<style>=0A<!--=0A/* Fon=
t Definitions */=...@font-face=0a=a0=a0=a0 {font-family:Calibri;=0A=A0=A0=A0=
panose-1:2 15 5 2 2 2 4 3 2 4;}...@font-face=0a=a0=a0=a0 {font-family:Taho=
ma;=0A=A0=A0=A0 panose-1:2 11 6 4 3 5 4 4 2 4;}=0A/* Style Definitions */=
=0Ap.MsoNormal, li.MsoNormal, div.MsoNormal=0A=A0=A0=A0 {margin:0in;=0A=A0=
=A0=A0 margin-bottom:.0001pt;=0A=A0=A0=A0 font-size:12.0pt;=0A=A0=A0=A0 fon=
t-family:"Times New Roman","serif";}=0Aa:link, span.MsoHyperlink=0A=A0=A0=
=A0 {mso-style-priority:99;=0A=A0=A0=A0 color:blue;=0A=A0=A0=A0 text-decora=
tion:underline;}=0Aa:visited, span.MsoHyperlinkFollowed=0A=A0=A0=A0 {mso-st=
yle-priority:99;=0A=A0=A0=A0 color:purple;=0A=A0=A0=A0 text-decoration:unde=
rline;}=0Aspan.EmailStyle17=0A=A0=A0=A0 {mso-style-type:personal-reply;=0A=
=A0=A0=A0 font-family:"Calibri","sans-serif";=0A=A0=A0=A0 color:#1F497D;}=
=0A.MsoChpDefault=0A=A0=A0=A0 {mso-style-type:export-only;=0A=A0=A0=A0 font=
-size:10.0pt;}...@page Section1=0A=A0=A0=A0 {size:8.5in 11.0in;=0A=A0=A0=A0=
margin:1.0in 1.0in 1.0in 1.0in;}=0Adiv.Section1=0A=A0=A0=A0 {page:Section1=
;}=0A-->=0A</style>=0A<!--[if gte mso 9]><xml>=0A<o:shapedefaults v:ext=3D3=
D"edit" spidmax=3D3D"1026" />=0A</xml><![endif]--><!--[if gte mso 9]><xml>=
=0A<o:shapelayout v:ext=3D3D"edit">=0A=A0 <o:idmap v:ext=3D3D"edit" data=3D=
3D"1" />=0A</o:shapelayout></xml><![endif]-->=0A</head>=0A=0A<body lang=3D3=
DEN-US link=3D3Dblue vlink=3D3Dpurple>=0A=0A<div class=3D3DSection1>=0A=0A<=
p class=3D3DMsoNormal><span =3D=0Astyle=3D3D'font-size:11.0pt;font-family:"=
Calibri","sans-serif";=0Acolor:#1F497D'>I would write a nice script that de=
leted the records in =3D=0Ablocks=0Aof say 50-100k and run it at night. You=
could test it with a block of =3D=0A100=0Aduring operating hours just to g=
et an idea of the overhead then up to 1k=0A=3D=0Aif=0Athings looked good th=
ere for another baseline. But then again it depends=0A=3D=0Aon the=0Asize o=
f the record too, is there only 10 columns on the field or 100? =3D=0APurgi=
ng=0A1000 records with 1kb of data will go a lot smoother than purging 1000=
=3D=0Arecords=0Awith 50kb of data.<o:p></o:p></span></p>=0A=0A<p class=3D3=
DMsoNormal><span =3D=0Astyle=3D3D'font-size:11.0pt;font-family:"Calibri","s=
ans-serif";=0Acolor:#1F497D'><o:p> </o:p></span></p>=0A=0A<div style=
=3D3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =3D=0A0in 0i=
n 0in'>=0A=0A<p class=3D3DMsoNormal><b><span =3D=0Astyle=3D3D'font-size:10.=
0pt;font-family:"Tahoma","sans-serif"'>From:</span=0A>=3D=0A</b><span=0Asty=
le=3D3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Action =3D=0AR=
equest=0ASystem discussion list(ARSList) [mailto:[email protected]] <b>On=
=3D=0ABehalf Of </b>Sean=0AHarrodine<br>=0A<b>Sent:</b> Thursday, November=
19, 2009 8:58 AM<br>=0A<b>To:</b> [email protected]<br>=0A<b>Subject:</b=
> Deleting a form with 2 million =3D=0Arecords<o:p></o:p></span></p>=0A=0A<=
/div>=0A=0A<p class=3D3DMsoNormal><o:p> </o:p></p>=0A=0A<p class=3D3DM=
soNormal>** <o:p></o:p></p>=0A=0A<div>=0A=0A<div>=0A=0A<p class=3D3DMsoNorm=
al><span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'=
>Hi=0Aall,<o:p></o:p></span></p>=0A=0A</div>=0A=0A<div>=0A=0A<p class=3D3DM=
soNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"Arial","sans-s=
erif"'> <o:p></=0Ao=3D=0A:p></span></p>=0A=0A</div>=0A=0A<div>=0A=0A<p=
class=3D3DMsoNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"Ar=
ial","sans-serif"'>I need=0Ato delete a form and the 2 million re=
cords stored in =3D=0Ait.<o:p></o:p></span></p>=0A=0A</div>=0A=0A<div>=0A=
=0A<p class=3D3DMsoNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font-famil=
y:"Arial","sans-serif"'> <o:p></=0Ao=3D=0A:p></span></p>=0A=0A</div>=
=0A=0A<div>=0A=0A<p class=3D3DMsoNormal><span =3D=0Astyle=3D3D'font-size:8.=
0pt;font-family:"Arial","sans-serif"'>Can=0Aanyone elighten me please as to=
the best and safest way to delete the =3D=0Atable=0Awith the least amount =
of impact on the system ie, without spiking the =3D=0AOracle=0Aarchive logs=
.<o:p></o:p></span></p>=0A=0A</div>=0A=0A<div>=0A=0A<p class=3D3DMsoNormal>=
<span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&n=
bsp;<o:p></=0Ao=3D=0A:p></span></p>=0A=0A</div>=0A=0A<div>=0A=0A<p class=3D=
3DMsoNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"Arial","san=
s-serif"'>Is=0Ait best to remove some or most of the records by using an AR=
SPerl=0A"DeleteEntry" script first, before blowing the form away =
in =3D=0Athe Admin=0Atool, or is there another way that that i'm not savvy =
too =3D=0A?<o:p></o:p></span></p>=0A=0A</div>=0A=0A<div>=0A=0A<p class=3D3D=
MsoNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"Arial","sans-=
serif"'> <o:p></=0Ao=3D=0A:p></span></p>=0A=0A</div>=0A=0A<div>=0A=0A<=
p class=3D3DMsoNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font-family:"A=
rial","sans-serif"'>TIA,<o:p></o:=0Ap=3D=0A></span></p>=0A=0A</div>=0A=0A<d=
iv>=0A=0A<p class=3D3DMsoNormal><span =3D=0Astyle=3D3D'font-size:8.0pt;font=
-family:"Arial","sans-serif"'>Sean<o:p></o:=0Ap=3D=0A></span></p>=0A=0A</di=
v>=0A=0A</div>=0A=0A<p class=3D3DMsoNormal><o:p> </o:p></p>=0A=0A<p cl=
ass=3D3DMsoNormal>_Platinum Sponsor: [email protected] =3D=0AARSlist=
:=0A"Where the Answers Are"_<o:p></o:p></p>=0A=0A</div>=0A=0A</bo=
dy>=0A=0A</html>=0A_Platinum Sponsor: [email protected] ARSlist: "Wh=
ere the Answers=0AAre"_=0A=0A------_=3D_NextPart_001_01CA692A.3580FDC6--=0A=
=0A________________________________________________________________________=
_______=0AUNSUBSCRIBE or access ARSlist Archives at www.arslist.org=0APlati=
num Sponsor:[email protected] ARSlist: "Where the Answers Are"=0A=0A=
=0A=0A
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
--0-441308472-1258644323=:25356
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
**
<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial, helvetica, sans-serif;font-size:8=
pt"><DIV>Hi David,</DIV>=0A<DIV> </DIV>=0A<DIV>Yes, at a database=
level is another option and access is "available" to me ;o)</DIV>=0A<=
DIV> </DIV>=0A<DIV>Presumably then, its just a quick visit to the admi=
n tool to remove the form then afterwards and any workflow ???</DIV>=
=0A<DIV> </DIV>=0A<DIV>rgds,</DIV>=0A<DIV>Sean<BR></DIV>=0A<DIV style=
=3D"FONT-SIZE: 8pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>=0A<DIV =
style=3D"FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif"><FONT =
face=3DTahoma size=3D2>=0A<HR SIZE=3D1>=0A<B><SPAN style=3D"FONT-WEIGHT: bo=
ld">From:</SPAN></B> David Morgan <[email protected]><BR><B><S=
PAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> [email protected]<BR><B><S=
PAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Thu, 19 November, 2009 15:=
14:50<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> Re: Delet=
ing a form with 2 million records<BR></FONT><BR>Hi Sean<BR><BR>Is it possib=
le to access it via the database and use :-<BR> truncate =
table Txxx ; <BR> truncate table Bxxx ; <BR> &=
nbsp; truncate table Hxxx ;<BR><BR>where xxx is the schemaid of the table (=
select name, schemaid from<BR>arschema where name =3D 'FORM NAME';)<BR><BR>=
so as to empty the records therein, before deleting the form?<BR>That's pro=
bably the quickest way. <BR><BR>Regards<BR>Dave Morgan<BR><BR><BR>-----Orig=
inal Message-----<BR>From: Action Request System discussion list(ARSList)<B=
R>[mailto:<A
href=3D"mailto:[email protected]" ymailto=3D"mailto:[email protected]"=
>[email protected]</A>] On Behalf Of Tommy Morris<BR>Sent: 19 November 20=
09 15:09<BR>To: <A href=3D"mailto:[email protected]" ymailto=3D"mailto:ar=
[email protected]">[email protected]</A><BR>Subject: Re: Deleting a form =
with 2 million records<BR><BR>This is a multi-part message in MIME format.<=
BR><BR>------_=3D_NextPart_001_01CA692A.3580FDC6<BR>Content-Type: text/plai=
n;<BR> charset=3D"us-ascii"<BR>Content-Transfer-Encoding:=
quoted-printable<BR><BR>I would write a nice script that deleted the recor=
ds in blocks of say<BR>50-100k and run it at night. You could test it with =
a block of 100<BR>during operating hours just to get an idea of the overhea=
d then up to 1k<BR>if things looked good there for another baseline. But th=
en again it<BR>depends on the size of the record too, is there only 10 colu=
mns on the<BR>field or 100? Purging 1000 records with 1kb of data will go a
lot<BR>smoother than purging 1000 records with 50kb of data.<BR><BR>=3D20<=
BR><BR>From: Action Request System discussion list(ARSList)<BR>[mailto:<A h=
ref=3D"mailto:[email protected]" ymailto=3D"mailto:[email protected]">a=
[email protected]</A>] On Behalf Of Sean Harrodine<BR>Sent: Thursday, Nove=
mber 19, 2009 8:58 AM<BR>To: <A href=3D"mailto:[email protected]" ymailto=
=3D"mailto:[email protected]">[email protected]</A><BR>Subject: Deletin=
g a form with 2 million records<BR><BR>=3D20<BR><BR>**=3D20<BR><BR>Hi all,<=
BR><BR>=3D20<BR><BR>I need to delete a form and the 2 million records store=
d in it.<BR><BR>=3D20<BR><BR>Can anyone elighten me please as to the best a=
nd safest way to delete<BR>the table with the least amount of impact on the=
system ie, without<BR>spiking the Oracle archive logs.<BR><BR>=3D20<BR><BR=
>Is it best to remove some or most of the records by using an ARSPerl<BR>"D=
eleteEntry" script first, before blowing the form away in the Admin<BR>tool=
, or is there
another way that that i'm not savvy too ?<BR><BR>=3D20<BR><BR>TIA,<BR><BR>=
Sean<BR><BR>=3D20<BR><BR>_Platinum Sponsor: <A href=3D"mailto:rmisoluti...@=
verizon.net" ymailto=3D"mailto:[email protected]">rmisoluti...@veriz=
on.net</A> ARSlist: "Where the Answers<BR>Are"_<BR><BR><BR>________________=
________________________________________________________<BR>_______<BR>UNSU=
BSCRIBE or access ARSlist Archives at www.arslist.org<BR>Platinum Sponsor:<=
A href=3D"mailto:[email protected]" ymailto=3D"mailto:rmisoluti...@v=
erizon.net">[email protected]</A> ARSlist: "Where the Answers<BR>Are=
"<BR><BR>------_=3D_NextPart_001_01CA692A.3580FDC6<BR>Content-Type: text/ht=
ml;<BR> charset=3D"us-ascii"<BR>Content-Transfer-Encoding=
: quoted-printable<BR><BR>**<BR><html xmlns:v=3D3D"urn:schemas-microsoft=
-com:vml" =3D<BR>xmlns:o=3D3D"urn:schemas-microsoft-com:office:office" =3D<=
BR>xmlns:w=3D3D"urn:schemas-microsoft-com:office:word"
=3D<BR>xmlns:x=3D3D"urn:schemas-microsoft-com:office:excel" =3D<BR>xmlns:p=
=3D3D"urn:schemas-microsoft-com:office:powerpoint" =3D<BR>xmlns:a=3D3D"urn:=
schemas-microsoft-com:office:access" =3D<BR>xmlns:dt=3D3D"uuid:C2F41010-65B=
3-11d1-A29F-00AA00C14882" =3D<BR>xmlns:s=3D3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-=
00AA00C14882" =3D<BR>xmlns:rs=3D3D"urn:schemas-microsoft-com:rowset" xmlns:=
z=3D3D"#RowsetSchema"<BR>=3D<BR>xmlns:b=3D3D"urn:schemas-microsoft-com:offi=
ce:publisher" =3D<BR>xmlns:ss=3D3D"urn:schemas-microsoft-com:office:spreads=
heet" =3D<BR>xmlns:c=3D3D"urn:schemas-microsoft-com:office:component:spread=
sheet" =3D<BR>xmlns:odc=3D3D"urn:schemas-microsoft-com:office:odc" =3D<BR>x=
mlns:oa=3D3D"urn:schemas-microsoft-com:office:activation" =3D<BR>xmlns:html=
=3D3D"<A href=3D"http://www.w3.org/TR/REC-html40" target=3D_blank>http://ww=
w.w3.org/TR/REC-html40</A>" =3D<BR>xmlns:q=3D3D"<A href=3D"http://schemas.x=
mlsoap.org/soap/envelope/" target=3D_blank>http://schemas.xmlsoap.org/soap/=
envelope/</A>" =3D<BR>xmlns:rtc=3D3D"<A
href=3D"http://microsoft.com/officenet/conferencing" target=3D_blank>http:=
//microsoft.com/officenet/conferencing</A>" =3D<BR>xmlns:D=3D3D"DAV:" xmlns=
:Repl=3D3D"<A href=3D"http://schemas.microsoft.com/repl/" target=3D_blank>h=
ttp://schemas.microsoft.com/repl/</A>" =3D<BR>xmlns:mt=3D3D"<A href=3D"http=
://schemas.microsoft.com/sharepoint/soap/meetings/" target=3D_blank>http://=
schemas.microsoft.com/sharepoint/soap/meetings/</A>" =3D<BR>xmlns:x2=3D3D"<=
A href=3D"http://schemas.microsoft.com/office/excel/2003/xml" target=3D_bla=
nk>http://schemas.microsoft.com/office/excel/2003/xml</A>" =3D<BR>xmlns:ppd=
a=3D3D"<A href=3D"http://www.passport.com/NameSpace.xsd" target=3D_blank>ht=
tp://www.passport.com/NameSpace.xsd</A>" =3D<BR>xmlns:ois=3D3D"<A href=3D"h=
ttp://schemas.microsoft.com/sharepoint/soap/ois/" target=3D_blank>http://sc=
hemas.microsoft.com/sharepoint/soap/ois/</A>" =3D<BR>xmlns:dir=3D3D"<A href=
=3D"http://schemas.microsoft.com/sharepoint/soap/directory/"
target=3D_blank>http://schemas.microsoft.com/sharepoint/soap/directory/</A=
>" =3D<BR>xmlns:ds=3D3D"<A href=3D"http://www.w3.org/2000/09/xmldsig#" targ=
et=3D_blank>http://www.w3.org/2000/09/xmldsig#</A>" =3D<BR>xmlns:dsp=3D3D"<=
A href=3D"http://schemas.microsoft.com/sharepoint/dsp" target=3D_blank>http=
://schemas.microsoft.com/sharepoint/dsp</A>" =3D<BR>xmlns:udc=3D3D"<A href=
=3D"http://schemas.microsoft.com/data/udc" target=3D_blank>http://schemas.m=
icrosoft.com/data/udc</A>" =3D<BR>xmlns:xsd=3D3D"<A href=3D"http://www.w3.o=
rg/2001/XMLSchema" target=3D_blank>http://www.w3.org/2001/XMLSchema</A>" =
=3D<BR>xmlns:sub=3D3D"<A href=3D"http://schemas.microsoft.com/sharepoint/so=
ap/2002/1/alerts/" target=3D_blank>http://schemas.microsoft.com/sharepoint/=
soap/2002/1/alerts/</A><BR>"=3D<BR>xmlns:ec=3D3D"<A href=3D"http://www.w3.o=
rg/2001/04/xmlenc#" target=3D_blank>http://www.w3.org/2001/04/xmlenc#</A>" =
=3D<BR>xmlns:sp=3D3D"<A href=3D"http://schemas.microsoft.com/sharepoint/"
target=3D_blank>http://schemas.microsoft.com/sharepoint/</A>" =3D<BR>xmlns=
:sps=3D3D"<A href=3D"http://schemas.microsoft.com/sharepoint/soap/" target=
=3D_blank>http://schemas.microsoft.com/sharepoint/soap/</A>" =3D<BR>xmlns:x=
si=3D3D"<A href=3D"http://www.w3.org/2001/XMLSchema-instance" target=3D_bla=
nk>http://www.w3.org/2001/XMLSchema-instance</A>" =3D<BR>xmlns:udcs=3D3D"<A=
href=3D"http://schemas.microsoft.com/data/udc/soap" target=3D_blank>http:/=
/schemas.microsoft.com/data/udc/soap</A>" =3D<BR>xmlns:udcxf=3D3D"<A href=
=3D"http://schemas.microsoft.com/data/udc/xmlfile" target=3D_blank>http://s=
chemas.microsoft.com/data/udc/xmlfile</A>" =3D<BR>xmlns:udcp2p=3D3D"<A href=
=3D"http://schemas.microsoft.com/data/udc/parttopart" target=3D_blank>http:=
//schemas.microsoft.com/data/udc/parttopart</A>" =3D<BR>xmlns:wf=3D3D"<A hr=
ef=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/" target=3D_bla=
nk>http://schemas.microsoft.com/sharepoint/soap/workflow/</A>" =3D<BR>xmlns=
:dsss=3D3D"<A
href=3D"http://schemas.microsoft.com/office/2006/digsig-setup" target=3D_b=
lank>http://schemas.microsoft.com/office/2006/digsig-setup</A>" =3D<BR>xmln=
s:dssi=3D3D"<A href=3D"http://schemas.microsoft.com/office/2006/digsig" tar=
get=3D_blank>http://schemas.microsoft.com/office/2006/digsig</A>" =3D<BR>xm=
lns:mdssi=3D3D"<A href=3D"http://schemas.openxmlformats.org/package/2006/di=
gital-si" target=3D_blank>http://schemas.openxmlformats.org/package/2006/di=
gital-si</A><BR>g=3D<BR>nature" =3D<BR>xmlns:mver=3D3D"<A href=3D"http://sc=
hemas.openxmlformats.org/markup-compatibility/200" target=3D_blank>http://s=
chemas.openxmlformats.org/markup-compatibility/200</A><BR>6=3D<BR>" xmlns:m=
=3D3D"<A href=3D"http://schemas.microsoft.com/office/2004/12/omml" target=
=3D_blank>http://schemas.microsoft.com/office/2004/12/omml</A>" =3D<BR>xmln=
s:mrels=3D3D"<A href=3D"http://schemas.openxmlformats.org/package/2006/rela=
tionsh" target=3D_blank>http://schemas.openxmlformats.org/package/2006/rela=
tionsh</A><BR>i=3D<BR>ps" xmlns:spwp=3D3D"<A
href=3D"http://microsoft.com/sharepoint/webpartpages" target=3D_blank>http=
://microsoft.com/sharepoint/webpartpages</A>" =3D<BR>xmlns:ex12t=3D3D"<A hr=
ef=3D"http://schemas.microsoft.com/exchange/services/2006/types" target=3D_=
blank>http://schemas.microsoft.com/exchange/services/2006/types</A><BR>"=3D=
<BR>=3D<BR>xmlns:ex12m=3D3D"<A href=3D"http://schemas.microsoft.com/exchang=
e/services/2006/messa" target=3D_blank>http://schemas.microsoft.com/exchang=
e/services/2006/messa</A><BR>g=3D<BR>es" =3D<BR>xmlns:pptsl=3D3D"<A href=3D=
"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary" target=3D_blank=
>http://schemas.microsoft.com/sharepoint/soap/SlideLibrary</A><BR>/=3D<BR>"=
=3D<BR>xmlns:spsl=3D3D"<A href=3D"http://microsoft.com/webservices/SharePo=
intPortalServer/Pu" target=3D_blank>http://microsoft.com/webservices/ShareP=
ointPortalServer/Pu</A><BR>b=3D<BR>lishedLinksService" xmlns:Z=3D3D"urn:sch=
emas-microsoft-com:" =3D<BR>xmlns:st=3D3D"" xmlns=3D3D"<A href=3D"http://ww=
w.w3.org/TR/REC-html40"
target=3D_blank>http://www.w3.org/TR/REC-html40</A>"><BR><BR><head&g=
t;<BR><meta http-equiv=3D3DContent-Type content=3D3D"text/html; =3D<BR>c=
harset=3D3Dus-ascii"><BR><meta name=3D3DGenerator content=3D3D"Micros=
oft Word 12 (filtered medium)"><BR><style><BR><!--<BR>/* Font D=
efinitions */<BR>@font-face<BR> {font-family:Calibri;<BR>=
panose-1:2 15 5 2 2 2 4 3 2 4;}<BR>@font-face<BR> &=
nbsp; {font-family:Tahoma;<BR> panose-1:2 11 6 4 3 =
5 4 4 2 4;}<BR>/* Style Definitions */<BR>p.MsoNormal, li.MsoNormal, div.Ms=
oNormal<BR> {margin:0in;<BR> margin-bot=
tom:.0001pt;<BR> font-size:12.0pt;<BR> =
font-family:"Times New Roman","serif";}<BR>a:link, span.MsoHyperlink<BR>&nb=
sp; {mso-style-priority:99;<BR> color:blue;<B=
R> text-decoration:underline;}<BR>a:visited,
span.MsoHyperlinkFollowed<BR> {mso-style-priority:99;<BR=
> color:purple;<BR> text-decoration:und=
erline;}<BR>span.EmailStyle17<BR> {mso-style-type:persona=
l-reply;<BR> font-family:"Calibri","sans-serif";<BR> =
; color:#1F497D;}<BR>.MsoChpDefault<BR> {mso-=
style-type:export-only;<BR> font-size:10.0pt;}<BR>@page S=
ection1<BR> {size:8.5in 11.0in;<BR> mar=
gin:1.0in 1.0in 1.0in 1.0in;}<BR>div.Section1<BR> {page:S=
ection1;}<BR>--><BR></style><BR><!--[if gte mso 9]><xml&g=
t;<BR><o:shapedefaults v:ext=3D3D"edit" spidmax=3D3D"1026" /><BR><=
/xml><![endif]--><!--[if gte mso 9]><xml><BR><o:sha=
pelayout v:ext=3D3D"edit"><BR> <o:idmap v:ext=3D3D"edit" data=
=3D3D"1"
/><BR></o:shapelayout></xml><![endif]--><BR></head=
><BR><BR><body lang=3D3DEN-US link=3D3Dblue vlink=3D3Dpurple><BR><=
BR><div class=3D3DSection1><BR><BR><p class=3D3DMsoNormal><s=
pan =3D<BR>style=3D3D'font-size:11.0pt;font-family:"Calibri","sans-serif";<=
BR>color:#1F497D'>I would write a nice script that deleted the records i=
n =3D<BR>blocks<BR>of say 50-100k and run it at night. You could test it wi=
th a block of =3D<BR>100<BR>during operating hours just to get an idea of t=
he overhead then up to 1k<BR>=3D<BR>if<BR>things looked good there for anot=
her baseline. But then again it depends<BR>=3D<BR>on the<BR>size of the rec=
ord too, is there only 10 columns on the field or 100? =3D<BR>Purging<BR>10=
00 records with 1kb of data will go a lot smoother than purging 1000 =3D<BR=
>records<BR>with 50kb of data.<o:p></o:p></span></p>=
;<BR><BR><p class=3D3DMsoNormal><span
=3D<BR>style=3D3D'font-size:11.0pt;font-family:"Calibri","sans-serif";<BR>=
color:#1F497D'><o:p>&nbsp;</o:p></span></p><=
BR><BR><div style=3D3D'border:none;border-top:solid #B5C4DF 1.0pt;paddin=
g:3.0pt =3D<BR>0in 0in 0in'><BR><BR><p class=3D3DMsoNormal><b&g=
t;<span =3D<BR>style=3D3D'font-size:10.0pt;font-family:"Tahoma","sans-se=
rif"'>From:</span<BR>>=3D<BR></b><span<BR>style=3D3D'font=
-size:10.0pt;font-family:"Tahoma","sans-serif"'> Action =3D<BR>Request<B=
R>System discussion list(ARSList) [mailto:<A href=3D"mailto:arsl...@arslist=
.ORG" ymailto=3D"mailto:[email protected]">[email protected]</A>] <b=
>On =3D<BR>Behalf Of </b>Sean<BR>Harrodine<br><BR><b>S=
ent:</b> Thursday, November 19, 2009 8:58 AM<br><BR><b>To=
:</b> <A href=3D"mailto:[email protected]" ymailto=3D"mailto:arslis=
[email protected]">[email protected]</A><br><BR><b>Subject:</b=
> Deleting a form
with 2 million =3D<BR>records<o:p></o:p></span></p>=
;<BR><BR></div><BR><BR><p class=3D3DMsoNormal><o:p>&n=
bsp;</o:p></p><BR><BR><p class=3D3DMsoNormal>** <o:p&g=
t;</o:p></p><BR><BR><div><BR><BR><div><BR><BR><p=
class=3D3DMsoNormal><span =3D<BR>style=3D3D'font-size:8.0pt;font-fam=
ily:"Arial","sans-serif"'>Hi<BR>all,<o:p></o:p></span>=
</p><BR><BR></div><BR><BR><div><BR><BR><p class=3D3DMs=
oNormal><span =3D<BR>style=3D3D'font-size:8.0pt;font-family:"Arial","=
sans-serif"'>&nbsp;<o:p></<BR>o=3D<BR>:p></span>&l=
t;/p><BR><BR></div><BR><BR><div><BR><BR><p class=3D3DMsoN=
ormal><span =3D<BR>style=3D3D'font-size:8.0pt;font-family:"Arial","sa=
ns-serif"'>I&nbsp;need<BR>to delete a form and the&nbsp;2 millio=
n records stored in
=3D<BR>it.<o:p></o:p></span></p><BR><BR></div&g=
t;<BR><BR><div><BR><BR><p class=3D3DMsoNormal><span =3D<BR>s=
tyle=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&nbsp;&l=
t;o:p></<BR>o=3D<BR>:p></span></p><BR><BR></div>=
<BR><BR><div><BR><BR><p class=3D3DMsoNormal><span =3D<BR>sty=
le=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Can<BR>anyone =
elighten me please as to the best and safest way to delete the =3D<BR>table=
<BR>with the least amount of impact on the system ie, without spiking the =
=3D<BR>Oracle<BR>archive logs.<o:p></o:p></span></p>=
;<BR><BR></div><BR><BR><div><BR><BR><p class=3D3DMsoNormal&g=
t;<span =3D<BR>style=3D3D'font-size:8.0pt;font-family:"Arial","sans-seri=
f"'>&nbsp;<o:p></<BR>o=3D<BR>:p></span></p><=
BR><BR></div><BR><BR><div><BR><BR><p class=3D3DMsoNormal>=
<span
=3D<BR>style=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Is<=
BR>it best to remove some or most of the records by using an ARSPerl<BR>&am=
p;quot;DeleteEntry&quot; script first, before blowing the form away in =
=3D<BR>the Admin<BR>tool, or is there another way that that i'm not savvy t=
oo =3D<BR>?<o:p></o:p></span></p><BR><BR></div&g=
t;<BR><BR><div><BR><BR><p class=3D3DMsoNormal><span =3D<BR>s=
tyle=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&nbsp;&l=
t;o:p></<BR>o=3D<BR>:p></span></p><BR><BR></div>=
<BR><BR><div><BR><BR><p class=3D3DMsoNormal><span =3D<BR>sty=
le=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>TIA,<o:p>=
;</o:<BR>p=3D<BR>></span></p><BR><BR></div><BR><BR>=
<div><BR><BR><p class=3D3DMsoNormal><span
=3D<BR>style=3D3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Sea=
n<o:p></o:<BR>p=3D<BR>></span></p><BR><BR></div&=
gt;<BR><BR></div><BR><BR><p class=3D3DMsoNormal><o:p>&=
;nbsp;</o:p></p><BR><BR><p class=3D3DMsoNormal>_Platinum =
Sponsor: <A href=3D"mailto:[email protected]" ymailto=3D"mailto:rmis=
[email protected]">[email protected]</A> =3D<BR>ARSlist:<BR>&=
quot;Where the Answers Are&quot;_<o:p></o:p></p><BR><=
BR></div><BR><BR></body><BR><BR></html><BR>_Platinum Spon=
sor: <A href=3D"mailto:[email protected]" ymailto=3D"mailto:rmisolut=
[email protected]">[email protected]</A> ARSlist: "Where the Answers<=
BR>Are"_<BR><BR>------_=3D_NextPart_001_01CA692A.3580FDC6--<BR><BR>________=
_______________________________________________________________________<BR>=
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<BR>Platinum Spons=
or:<A
href=3D"mailto:[email protected]" ymailto=3D"mailto:rmisoluti...@ve=
rizon.net">[email protected]</A> ARSlist: "Where the Answers Are"<BR=
></DIV></DIV><!-- cg10.c41.mail.ird.yahoo.com compressed/chunked Thu Nov 19=
07:16:14 PST 2009 --></div><br>=0A=0A=0A=0A </body></html>
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
--0-441308472-1258644323=:25356--
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"