备份整个schema的数据

1备份整个schema下的表

select 'insert into migdev_backup.'|| tabname || '(select * from migdev.'|| tabname || ');' from syscat.tables where TABSCHEMA ='MIGDEV';

 

posted @ 2016-10-18 15:37  924249386  阅读(550)  评论(0编辑  收藏  举报