Database Administration (MOSC)

MOSC Banner

Where is a sequence dependency to table stored within data dictionary?

edited May 7, 2019 12:34PM in Database Administration (MOSC) 6 commentsAnswered

Table could have dependency to a sequence in its DDL.

In case of dropped sequence inserts into table will fail due to missing sequence.

I would like to check tables for which inserts will fail due to missing dependency.

Where is the sequence dependency between table and sequence strored within data dictionary?

Simple example:

create sequence seq1;

create table tab1

( col1 number default seq1.nextval not null,

  col2 number generated by default as identity not null

);

Developer has created sequence and table like above, inserted many rows into table, later wanted to rename sequence, dropped sequence seq1, created sequence seq2.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center