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?

thanks

In article <1076935173.330.0@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

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

1) By querying v$SQLTEXT for the SQL that contains sequence names

2) 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_ad...isclaimer.html






"Jeremy" <newspostings@hazelweb.co.uk> wrote in message
news:MPG.1a9af91df11395fa989ab8@news.individual.ne t...
> In article <1076935173.330.0@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

"Ron" <support@dbainfopower.com> wrote in message
news: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
>
> 1) By querying v$SQLTEXT for the SQL that contains sequence names
>
> 2) Checking table triggers - they may use corresponding sequences as
> well.

thanks all - managed to get the info out of user sequences got it!

thanks