Message-Id: <25937.338125@fatcity.com> From: "Jamadagni, Rajendra" Date: Wed, 16 Jul 2003 15:31:20 -0400 Subject: RE: Find the table's name that using sequences 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@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 RE: Find the table's name that using sequences

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@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-- ------=_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