Oracle export SEQUENCE.

select trim(DBMS_METADATA.GET_DDL('SEQUENCE',a.OBJECT_NAME, a.OWNER)) "SEQUENCE_DDL"
from dba_objects a
where a.OBJECT_TYPE ='SEQUENCE'
and a.OWNER in ('USERNAME')
order by a.OWNER, a.OBJECT_NAME;
    

Kopieren