RE: [PMX:#] RE: Find the table's name that using sequences

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 17 Jul 2003 11:54:05 -0400
Message-Id: <25946.338271@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------=_NextPartTM-000-34bef911-cc0c-40b8-9353-a338c686d20a Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C34C7B.A6B8BB9E"

------_=_NextPart_001_01C34C7B.A6B8BB9E
Content-Type: text/plain;

charset="iso-8859-1"

Very True ...

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com] Sent: Wednesday, July 16, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L Subject: [PMX:#] RE: Find the table's name that using sequences

this doesn't take into account external code that uses the sequence....

there is no way to know for certain which sequence is being used to generate values for which table. Even if you have multiple sequences, you can't force a programmer to use the sequence you have designated as "the one" for that particular table

"Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> I'd check dependencies of the sequence, you'll know what
> procedures,functions,packages,triggers that sue the sequence.
>
> Raj

------_=_NextPart_001_01C34C7B.A6B8BB9E
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [PMX:#] RE: Find the table's name that using sequences</TITLE>
</HEAD>
<BODY>

Very True ...

<P><FONT SIZE=2>Raj</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Rajendra dot Jamadagni at nospamespn dot com</FONT>
<BR><FONT SIZE=2>All Views expressed in this email are strictly personal.</FONT>
<BR><FONT SIZE=2>QOTD: Any clod can have facts, having an opinion is an art !</FONT>
</P>
<BR>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Rachel Carmichael [<A HREF="mailto:wisernet100_at_yahoo.com">mailto:wisernet100_at_yahoo.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 16, 2003 5:25 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: [PMX:#] RE: Find the table's name that using sequences</FONT>

this doesn't take into account external code that uses the sequence....

<P><FONT SIZE=2>there is no way to know for certain which sequence is being used to</FONT>
<BR><FONT SIZE=2>generate values for which table. Even if you have multiple sequences,</FONT>
<BR><FONT SIZE=2>you can't force a programmer to use the sequence you have designated as</FONT>
<BR><FONT SIZE=2>&quot;the one&quot; for that particular table</FONT>
</P>
<BR>

<P><FONT SIZE=2>--- &quot;Jamadagni, Rajendra&quot; &lt;Rajendra.Jamadagni_at_espn.com&gt; wrote:</FONT>
<BR><FONT SIZE=2>&gt; I'd check dependencies of the sequence, you'll know what</FONT>
<BR><FONT SIZE=2>&gt; procedures,functions,packages,triggers that sue the sequence.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>

> Raj

</BODY>
</HTML>
------_=_NextPart_001_01C34C7B.A6B8BB9E--

------=_NextPartTM-000-34bef911-cc0c-40b8-9353-a338c686d20a Content-Type: text/plain;

name="ESPN_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;

filename="ESPN_Disclaimer.txt"

********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2

Received on Thu Jul 17 2003 - 10:54:05 CDT