Where is a sequence dependency to table stored within data dictionary?
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.