做循环清表的时候报这个错,有问题吗?是否需要解决这个报错,检查了下部分表,是已经被清空了
执行以下 SQL 失败
BEGIN FOR tables IN ( SELECT * FROM dba_tables WHERE owner = ‘XC_ABA’ AND table_name != ‘XCOBJECTS’ AND num_rows != 0 ) loop BEGIN DBMS_OUTPUT.PUT_LINE (‘truncate table ‘|| tables.owner ||’.’ || tables.TABLE_NAME||’;’); execute immediate ‘truncate table ‘|| tables.owner ||’.’ || tables.TABLE_NAME; END; END loop; END;
失败原因:
ErrorCode = 600, SQLState = HY000, Details = ORA-00600: internal error code, arguments: -5188, Too many partitions (including subpartitions) were defined at anonymous block , line : 15, col : 3