Re: Which columns use sequences (in 8i)?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 26 Feb 2003 20:20:55 -0800
Message-ID: <3E5D9227.3BB65E28@exesolutions.com>

John Peltonen wrote:

> I'm looking to migrate a tablespace and I need to know which columns
> in the tablespace have data generated by sequences. Does anyone have
> a quick way/suggestion for how I can find this out?
>
> My best guess is to write code that queries DBA_Triggers for all
> mentions of a specified sequence name, although that's a pain because
> the trigger_body is stuck in a LONG data type.
>
> Is there anything more efficient/quicker/easier out there for this?
>
> Thanks,
> John

There is no easy way to do it because sequences may be called from SQL statements issued from anywhere. They do not need to be in any way related to triggers.

I'd look at dba_dependencies and search for them in dba_source.

Daniel Morgan Received on Wed Feb 26 2003 - 22:20:55 CST