单独导出sequences

最新推荐文章于 2022-12-01 17:31:55 发布

lzq_19890403

最新推荐文章于 2022-12-01 17:31:55 发布

阅读量144

点赞数

本文链接：https://blog.csdn.net/lzq_19890403/article/details/84597522

版权

create table ddl_scripts(
object_name varchar2(50),
object_type varchar2(30),
text varchar2(4000));

declare
a1 varchar2(32767);
str varchar2(32767);
n1 number;
BEGIN
for c1 IN(select sequence_name from user_sequences order by 1) LOOP
select DBMS_LOB.SUBSTR(dbms_metadata.get_ddl('SEQUENCE', c1.sequence_name), 32767,1) INTO a1 from dual;
insert into ddl_scripts values(c1.sequence_name, 'SEQUENCE', a1);
END LOOP;
END;

/

执行语句： SELECT TEXT FROM DDL_SCRIPTS;