Solved

How can you tell if a table has a sequence associated?

Posted on 2009-07-13
3
233 Views
Last Modified: 2012-05-07
I have numerous tables that I created sequences for and now want to ensure the sequences are in place...how do you check for this?

Thx
0
Comment
Question by:Glen_D
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 24844553
you cannot. there is no dictionary indication in oracle for this.
you could check if there is a trigger on the table using a sequence, or some stored procedure doing the inserts while using the sequence, but it could be as well the client application itself.
0
 

Author Closing Comment

by:Glen_D
ID: 31603048
very surprized that you can't review all code within a db...thx
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24844725
you can "look" at all the code of the views, triggers, procedures etc:
select * from dba_code

however, to "analyse" it to find out if there is a insert/update using a given sequence on a given table is VERY far from trivial. peanuts for the human reader, but using some "code" to "understand" the code ...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question