07/08/09 20:36:03
>>704
以下のSQL使ってcreate文を作成して、それをユーザーBで流せ。。
select
'create sequence '||sequence_name||' start with '||to_char(last_number+1)||
' increment by '||increment_by||' maxvalue '||max_value||decode(nvl(cache_size,0),0,';',' cache '||cache_size||';') "Create Sequecne SQL"
from dba_sequences
where upper(sequence_owner) = upper('&Owner')
order by 1