I am creating a table with an identity column and later drop the table. The sequence associated with the identity column, however, is not dropped. This behavior is different from what I have observed in 19c.
Is this a bug or am I missing something.
The following statements reproduce the behavior on my system:
create table T (
id integer generated always as identity
);
drop table T;
select
(sysdate - created) * 24*60*60 created_secs_ago
from
user_objects
where
object_type = 'SEQUENCE' and
(sysdate - created) * 24*60*60 < 2;