Oracle 批量导入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) ||';'  //这个是实时的Sequence
from user_sequences

 

 

 

select  d.text,d.name  from   user_source    d  where  type   ='PROCEDURE' ; //查询所有存储过程

 

 

 

SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name)
  FROM USER_OBJECTS u
 where U.OBJECT_TYPE IN ('TABLE','INDEX','PROCEDURE','sequence');//得到一个用户下的所有表，索引，存储过程,sequence .......的ddl