How to export sequences using sql
Normally sequences are not exported if we give partial export. For such cases we can use sql to generate quries for sequence droping and creating select ‘drop sequence ‘||sequence_name||’;’ from user_sequences where sequence_name like’SEQ_DB%’; select ‘create sequence ‘||sequence_name|| ‘ minvalue ‘|| MIN_VALUE || ‘ maxvalue ‘|| MAX_VALUE || ‘ start with ‘||last_number|| ‘ increment by […]