SQL*Loader-937，并行直接路径导入限制
<DIV><H5><FONT face=宋体 size=3>周末的时候导了一批数据，使用了direct=true,parallel=true两个参数，7亿+条记录，没有索引，耗时8个多小时，还算是比较理想的。</FONT></H5><FONT face=宋体 size=3>
<H5><BR>昨天调整了另一个导入数据的脚本，加了个direct=true的参数。早上回到公司查看日志悲剧了。报了个SQL*Loader-937的错误。</H5><FONT size=3></FONT>
<H5><BR>SQL*Loader-937: parallel load requested and name has enabled triggers or constraints<BR>Cause: A request was made for a parallel direct load, but the object to be loaded has an enabled constraint (check, referential) and/or enabled triggers. <BR>Action: Disable the offending enabled constraints and/or triggers and retry the parallel direct load. </H5>
<H5><BR>原来对并行的直接路径导入有限制，表中不能有check，referential约束和触发器。</FONT></H5></DIV>
页:
[1]