RE: Find the table's name that using sequences

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 16 Jul 2003 15:31:20 -0400
Message-Id: <25937.338125@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-836d65c6-b4e8-492a-a501-0685d7b2c29e Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C34BD0.D585C3A0"

------_=_NextPart_001_01C34BD0.D585C3A0
Content-Type: text/plain;

charset="iso-8859-1"

I'd check dependencies of the sequence, you'll know what procedures,functions,packages,triggers that sue the sequence.

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 !

>>> mitchell.lee_at_rogers.com 07/16/03 03:09PM >>> Hi All

At first I thought it is easy to find those tables to use sequences but I failed. dba_sequence don't give too much info. Is there any idea?

Thanks in advance
Mitchell

------_=_NextPart_001_01C34BD0.D585C3A0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

I'd check dependencies of the sequence, you'll know =
what procedures,functions,packages,triggers that sue the = sequence.


Raj
 <FONT =

SIZE=3D2>---------------------------------------------------------------=
-----------------</FONT>

 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 !


>>> mitchell.lee_at_rogers.com 07/16/03 03:09PM =

&gt;&gt;&gt;</FONT>


<BR><FONT SIZE=3D2>Hi All</FONT>

  
 At first I thought it is easy to find those tables =
to use sequences but I failed.  dba_sequence don't give too much = info.  Is there any idea?

 
 Thanks in advance
 Mitchell


</BODY>
</HTML>

------_=_NextPart_001_01C34BD0.D585C3A0--

------=_NextPartTM-000-836d65c6-b4e8-492a-a501-0685d7b2c29e 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 Wed Jul 16 2003 - 14:31:20 CDT