How to import only sequences?

[gandolf989]

What about creating the sequences with dynamic sql?

SELECT  'DROP SEQUENCE '    || sequence_name  || ';' || CHR(10) ||
        'SELECT '           ||
      '''CREATE SEQUENCE '  || sequence_name ||
        ' INCREMENT BY '    || increment_by  ||
        ' START WITH ''||'  || sequence_name ||  '.NEXTVAL || ''' ||
        ' MINVALUE '        || MIN_VALUE     ||
        ' MAXVALUE '        || MAX_VALUE     ||
          CASE cycle_flag WHEN 'N' THEN ' NOCYCLE ' ELSE ' CYCLE ' END ||
          CASE order_flag WHEN 'N' THEN ' NOORDER ' ELSE ' ORDER ' END ||
        ' CACHE ' || CACHE_SIZE || ';'' FROM dual;' dyn_seq
  FROM user_sequences
 ORDER BY sequence_name;