Re: finding user sequences and values

From: Ron <support_at_dbainfopower.com>
Date: Mon, 16 Feb 2004 20:36:21 -0800
Message-ID: <b7adnW1e9-VcBazdRVn-tw@comcast.com>

Hello Tom,

As Jeremy mentioned, there is no direct association.

If you cannot get this information from developers, you may try to gather some related information

By querying v$SQLTEXT for the SQL that contains sequence names
Checking table triggers - they may use corresponding sequences as well.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1a9af91df11395fa989ab8_at_news.individual.net...
> In article <1076935173.330.0_at_damia.uk.clara.net>, Tom says...
> > Hi
> >
> > 9i on Linux
> >
> > How do i find the sequences that are associated with a particular user
and table? I need to query this value and then increment it
> > by around 1000.
> > Can anyone assist me with that?
> >
> Hi Tom, sequences are not tied to tables in any way.
>
> To see what sequences are owned by a user:
>
> select * from user_sequences;
>
>
> --
>
> jeremy
Received on Mon Feb 16 2004 - 22:36:21 CST