随笔- 110
文章- 0
评论- 29
导出建sequence的语句即可起到备份的作用
select 'create sequence '||sequence_name||
' minvalue '||min_value||
' maxvalue '||max_value||
' start with '||last_number||
' increment by '||increment_by||
(case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'
from dba_sequences where sequence_owner='ZA3607'
posted @ 2008-12-28 17:14 嘎子 阅读(962) 评论(0) 编辑
