From dwagoner@arsenaldigital.com Wed, 28 Nov 2001 15:29:03 -0800
From: David Wagoner <dwagoner@arsenaldigital.com>
Date: Wed, 28 Nov 2001 15:29:03 -0800
Subject: RE: Script to Disable Constraint, Change Value, then Enable Const
Message-ID: <F001.003CFA54.20011128134022@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain









<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>I know it
looks like a semi-colon error, but it&#8217;s not.<span style="mso-spacerun:
yes">  Please send me one of your examples that you know works and
I&#8217;ll modify and try here.

<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span 
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail 
Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue;
font-style:italic'>Database Administrator<font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue;mso-color-alt:windowtext;font-style:italic'>

<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue;
font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext;font-weight:bold'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>4815 Emperor
Blvd., Suite 110<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue;
mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Durham, NC 27703<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Tel. (919)
941-4645<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue;
mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Fax (919)
474-0735<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue;
mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Email <a
href="mailto:dwagoner@arsenaldigital.com"><span
style='font-family:"Times New Roman"'>mailto:dwagoner@arsenaldigital.com<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Web <a
href="http://www.arsenaldigital.com/"><span
style='font-family:"Times New Roman"'>http://www.arsenaldigital.com/<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'> <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'><span
style="mso-spacerun:
yes">                                                                                                         
<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>***<span
style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun:
yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue;
mso-color-alt:windowtext'>

<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail message
from your computer.  Thank you.<font
size=1 color=blue face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span
class=EmailStyle23><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: Cale, Rick T (Richard)
[mailto:RICHARD.T.CALE@saic.com]
Sent: Wednesday, November 28, 2001
2:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const

<span
style='font-size:12.0pt'> 

<span
style='font-size:10.0pt;font-family:Arial;color:blue'>David,<font
color=black>

<font size=3 color=black
face="Times New Roman"> <font
color=black>

<span
style='font-size:10.0pt;font-family:Arial;color:blue'>You need a semi-colon
after line2 i.e., update table1 ...;<span
style='color:black;mso-color-alt:windowtext'>

<font size=3 color=black
face="Times New Roman"> <font
color=black>

<span
style='font-size:10.0pt;font-family:Arial;color:blue'>Rick<font
color=black>

<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:1.0in'><span style='font-size:
10.0pt;font-family:Tahoma;color:black'>-----Original Message-----
From: David Wagoner
[mailto:dwagoner@arsenaldigital.com]
Sent: Wednesday, November 28, 2001
1:16 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const<span
style='color:black;mso-color-alt:windowtext'>

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Rick, thanks for your input.<span
style="mso-spacerun: yes">  When I test the deferred constraint in
SQL*Plus I get an error.  What am I
doing wrong?  I did not find much
information in the docs about deferred constraints.

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>  SQL>
set constraints all deferred

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style="mso-spacerun:
yes">        2<span
style="mso-spacerun: yes">  update table1 set host_name = 'tigerz'
where host_name = 'tiger'

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style="mso-spacerun:
yes">        3* update table2 set
host_name = 'tigerz' where host_name = 'tiger';

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>SQL> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>update host set host_name = 'tigerz' where host_name
= 'tiger'

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>*

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>ERROR at line 2:

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>ORA-00933: SQL command not properly ended

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>TIA,

<font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<!---size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-begin'> AUTOTEXTLIST 
\s "E-mail Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue;font-style:italic'>Database Administrator<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue;font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-weight:bold'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>4815 Emperor Blvd., Suite 110<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>Durham, NC 27703<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>Tel. (919) 941-4645<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>Fax (919) 474-0735<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>Email <font
face="Times New Roman">mailto:dwagoner@arsenaldigital.com<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>Web <font
face="Times New Roman">http://www.arsenaldigital.com/<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'> <span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>

<font size=2 color=blue
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'><span style="mso-spacerun:
yes">                                                                                                         
<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>***<span
style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun:
yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>

<font size=1 color=blue
face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:blue'>This e-mail message is confidential, intended only for the
named recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law.<span
style="mso-spacerun: yes">  If you have received this message in
error, or are not the named recipient(s), please immediately notify the sender
at (919) 941-4645 and delete this e-mail message from your computer.<span
style="mso-spacerun: yes">  Thank you.<font size=1
color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<!---size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-end'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 

<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: Cale, Rick T (Richard)
[mailto:RICHARD.T.CALE@saic.com]
Sent: Wednesday, November 28, 2001
12:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const<span
style='color:black;mso-color-alt:windowtext'>

<font size=3 color=black
face="Times New Roman"> <font
color=black>

<font size=2 color=blue
face=Arial>I have
had the same type of requirement and decided to use deferrable constraints. <font
color=black>

<font size=2 color=blue
face=Arial>Works
great!<span style='color:black;mso-color-alt:
windowtext'>

<font size=3 color=black
face="Times New Roman"> <font
color=black>

<font size=2 color=blue
face=Arial>Rick<font
color=black>

<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:2.0in'><span style='font-size:
10.0pt;font-family:Tahoma;color:black'>-----Original Message-----
From: Igor Neyman
[mailto:ineyman@perceptron.com]
Sent: Wednesday, November 28, 2001
11:56 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Script to Disable
Constraint, Change Value, then Enable Const<span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:10.0pt;color:black'>Not good approach.<font
color=black>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:10.0pt;color:black'>Instead, use 'deferrable constraints,
should work in your situation.<span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:12.0pt;color:black'> <span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:12.0pt;color:black'>Igor Neyman, OCP DBA
ineyman@perceptron.com
  <span style='color:black;mso-color-alt:
windowtext'>



<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face=Arial>-----
Original Message ----- <span
style='font-size:10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>





<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:
0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:Arial;color:black;font-weight:bold'>

From:<font size=2 color=black
face=Arial> <a
href="mailto:dwagoner@arsenaldigital.com" title="dwagoner@arsenaldigital.com">David
Wagoner 



<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:
0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:Arial;color:black'> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'>





<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black;
font-weight:bold'>To:<span
style='font-size:10.0pt;font-family:Arial;color:black'> <a
href="mailto:ORACLE-L@fatcity.com" title="ORACLE-L@fatcity.com">Multiple
recipients of list ORACLE-L <font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black;
font-weight:bold'>Sent:<span
style='font-size:10.0pt;font-family:Arial;color:black'> Wednesday, November 28,
2001 11:24 AM<span
style='font-size:10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black;
font-weight:bold'>Subject:<font size=2 color=black
face=Arial> RE:
Script to Disable Constraint, Change Value, then Enable Const<font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3 color=black
face="Times New Roman"> <font
color=black>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>I can see the
confusion here.  The point is not
to let someone enter data<font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>that would violate
the referential integrity.  Let me
explain with an<span
style='font-size:10.0pt;font-family:"Courier New";color:black;mso-color-alt:
windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>example:<font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><span
style="mso-spacerun: yes"> <font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>





<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>1.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:blue'>User wants to update a primary key record in parent
table<span
style='font-size:10.0pt;font-family:"Courier New";color:black;mso-color-alt:
windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>2.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:blue'>Dependent data exists in a child table so the user
gets an error while trying to perform step 1<font size=2
color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>3.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:blue'>It is necessary to disable the FK constraint in order
to update both tables<span
style='font-size:10.0pt;font-family:"Courier New";color:black;mso-color-alt:
windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>4.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:blue'>Enable the FK constraint successfully<font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black;mso-color-alt:windowtext'>





<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><span
style="mso-spacerun: yes"> <font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><span
style="mso-spacerun: yes"> <font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>Does that make
sense?  This is a process we have
to do routinely and it has<font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>happened in the
past that the FK was mistakenly not re-enabled, which<font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt:
0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>allowed
"illegal" data to be loaded later.<span style="mso-spacerun:
yes">  Thus the need for a script.<font size=2
color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle20><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle20><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><!---size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-begin'> AUTOTEXTLIST 
\s "E-mail Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-style:italic'>Database Administrator<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-weight:bold'>Arsenal Digital Solutions
Worldwide Inc.<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext;font-weight:bold'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>4815 Emperor Blvd., Suite 110<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>Durham, NC 27703<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>Tel. (919) 941-4645<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>Fax (919) 474-0735<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>Email <font
face="Times New Roman">mailto:dwagoner@arsenaldigital.com<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>Web <font
face="Times New Roman">http://www.arsenaldigital.com/<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'> <font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'><span style="mso-spacerun:
yes">                                                                                                         
<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>***<span
style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun:
yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=1
color=blue face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:blue'>This e-mail message is confidential, intended
only for the named recipient(s) above and may contain information that is
privileged, work product or exempt from disclosure under applicable law.<span
style="mso-spacerun: yes">  If you have received this message in
error, or are not the named recipient(s), please immediately notify the sender
at (919) 941-4645 and delete this e-mail message from your computer.<span
style="mso-spacerun: yes">  Thank you.<font size=1
color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><!---size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-end'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'> 





<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:black'>-----Original Message-----
From: Mark Leith
[mailto:mark@cool-tools.co.uk]
Sent: Wednesday, November 28, 2001
5:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Constrain<span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3
color=black face="Times New Roman"> <font
color=black>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>How could this be user proof? You are essentially disabling the
constraint that WILL enforce data integrity, then letting the user input
whatever rubbish he wants to, and are then going to try and enable the
constraint afterwards?<span style='color:black;
mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3
color=black face="Times New Roman"> <font
color=black>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>Not a good approach.. How can you ensure that the user hasn't put a
duplicate value in (unique constraint) or something else that might break the
constraint rule? The only way you are going to know is when you try and
re-enable the constraint it will fail.. <span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3
color=black face="Times New Roman"> <font
color=black>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'>I struggle to see why you would want to do this - do you have any
more info?<span style='color:black;mso-color-alt:
windowtext'>





<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:219.75pt;border:none;mso-border-left-alt:solid black 1.5pt;
padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black
face=Tahoma>-----Original
Message-----
From: root@fatcity.com
[mailto:root@fatcity.com]On Behalf Of David
Wagoner
Sent: 27 November 2001 21:30
To: Multiple recipients of list
ORACLE-L
Subject: Script to Disable Constraint,
Change Value, then Enable Constrain<span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Listers,

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Does anyone have a script
that will do the following:

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 





<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;
mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>1.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Accept user input for old data value<font
color=black> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;
mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>2.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Accept user input for new data value<font
color=black> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;
mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>3.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Disable table constraint<span
style='color:black'> <font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;
mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>4.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Update record with new data value<span
style='color:black'> <font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;
mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>5.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Enable constraint<span
style='color:black'> <font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'>





<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>A script like this would
help ensure that constraints are not left "off" after updates,
allowing "illegal" data into the tables.<span style="mso-spacerun:
yes">  Good user-proof script I would think.

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>TIA,

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>david

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=EmailStyle19><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span 
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail 
Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;font-style:italic'>Database Administrator<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;font-weight:bold'>Arsenal Digital
Solutions Worldwide Inc.<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:black;mso-color-alt:windowtext;font-weight:bold'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>4815 Emperor Blvd., Suite 110<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>Durham, NC 27703<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>Tel. (919) 941-4645<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>Fax (919) 474-0735<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>Email <a
href="mailto:dwagoner@arsenaldigital.com"><span
style='font-family:"Times New Roman"'>mailto:dwagoner@arsenaldigital.com<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>Web <font
face="Times New Roman">http://www.arsenaldigital.com/<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'> <font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'><span style="mso-spacerun:
yes">                                                                                                         
<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>***<span
style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun:
yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=1
color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black'>This e-mail message is confidential, intended
only for the named recipient(s) above and may contain information that is
privileged, work product or exempt from disclosure under applicable law.<span
style="mso-spacerun: yes">  If you have received this message in
error, or are not the named recipient(s), please immediately notify the sender
at (919) 941-4645 and delete this e-mail message from your computer.<span
style="mso-spacerun: yes">  Thank you.<font size=1
color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
color=black> <span
style='color:black;mso-color-alt:windowtext'>