I created a sequence with below sql on many environments:
CREATE SEQUENCE IMSDBA.BLTR_BATCH_SQNCE MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ;
grant select on IMSDBA.BLTR_BATCH_SQNCE to dmm_role;
but the odd thing is that I can`t get the row for the sequence from all_sequences but only dba_sequences.
and this is happening on only one of the environments. all the other envs are working as expected.
select * from ALL_sequences where sequence_owner='IMSDBA' and sequence_name='BLTR_BATCH_SQNCE';
select * from dba_sequences where sequence_owner='IMSDBA' and sequence_name='BLTR_BATCH_SQNCE';
Could anyone tell me why?