RE: Find the table's name that using sequences

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 16 Jul 2003 14:43:01 -0400
Message-Id: <25937.338110@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_006B_01C34BA8.8EEA6220 Content-Type: text/plain;

charset="us-ascii"
Content-Transfer-Encoding: 7bit

Sequence is not associated with any particular table. One sequence could be used to populate multiple tables.

If you know, that sequences are being used in "insert" triggers only (and not in the application outside the database), then you could search for sequence name in trigger_body of dba_triggers table.

Igor Neyman, OCP DBA

ineyman_at_perceptron.com

-----Original Message-----
From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of Mitchell
Sent: Wednesday, July 16, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L Subject: Find the table's name that using sequences

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_000_006B_01C34BA8.8EEA6220 Content-Type: text/html;

charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>Message</title>

<style>
<!--

/* Font Definitions */
@font-face

	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";}
span.EmailStyle17
	{font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}

-->
</style>

</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Sequence is not associated with any particular table.  One sequence could be used to populate multiple = tables.

If you know, that sequences are = being used
in “insert” triggers only (and not in the application = outside the
database), then you could search for sequence name in trigger_body of = dba_triggers
table.

<div>

Igor Neyman, OCP = DBA

ineyman_at_perceptron.com</font= >

</div>

-----Original = Message----- 
From: =

ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]

On Behalf Of Mitchell 
Sent: Wednesday, July 16, =
2003
2:09 PM 
To: Multiple recipients =
of list
ORACLE-L 
Subject: Find the table's =
name
that using sequences

<div>

Hi All

</div>

<div>

</div>

<div>

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?

</div>

<div>

</div>

<div>

Thanks in advance

</div>

<div>

<font size=3D2 =
Received on Wed Jul 16 2003 - 13:43:01 CDT