Hello,
Is it normal that system-sequences generated by IDENTITY columns are kept after dropping the table?
I expected that the automatic sequence is dropped implicitly...
SQL> create table t1 ( key integer generated by default as identity, c char(10) );
Table created.
SQL> select sequence_name from all_sequences where sequence_name like 'ISEQ%';
SEQUENCE_NAME
--------------------------------------------------------------------------------
ISEQ$$_94107
SQL> drop table t1;
Table dropped.
SQL> select sequence_name from all_sequences where sequence_name like 'ISEQ%';
SEQUENCE_NAME
--------------------------------------------------------------------------------
ISEQ$$_94107
SQL> create table t1 ( key integer generated by default as identity, c char(10) );
Table created.
SQL> select sequence_name from all_sequences where sequence_name like 'ISEQ%';
SEQUENCE_NAME
--------------------------------------------------------------------------------
ISEQ$$_94107
ISEQ$$_94109
2 rows selected.
Thanks
Seb