declare
v_cnt text;
begin
for rec in
(
select table_name,OWNER from all_tables where OWNER NOT LIKE 'SYS%' AND OWNER != 'CTISYS' order by 1
)
loop
execute immediate 'select DBMS_METADATA.GET_DDL(''TABLE'','''||rec.table_name||''','''||rec.OWNER||''') from dual' into v_cnt;
print(v_cnt);
end loop;
end;
通过管理工具生成
或者达梦迁移工具dts生成岂不是更快