Extract DDL for snapshots

[Shestakov]

set long 8000; (or less or more, as u need)

select query from ALL_SNAPSHOTS where owner='OOOO' and ....;