现在有一张表里面有2亿多条记录,我只需要2500万条记录,进行测试。我现在的思路是:
导出该表的结构,再导出该表的2500万条记录,进行重新建表
但是在导出表数据时,报错了,语句如下:
db2 "export to t1.ixf of ixf select * from smgsst.t_mngsrm_tran_log fetch frist 25000000 rows only"
SQL2437N The data movement command failed because the utility was unable to resolve how implicitly hidden columns should be processed. No data was moved.
请问专家,该如何解决该问题?
收起