I'm running a SQL*Loader CTL script that is reading a fixed position ASCII file into multiple tables using the Direct Load method. Everything is working great except for the fact that all of my foreign key constraints are being disabled.
I've added the clause "REENABLE DISABLED_CONSTRAINTS EXCEPTIONS myexcepttable" so that it will reenable the constraints at the end, but it doesn't appear to be reenabling the constraints. Additionally, the documentation says that the log file will indicate which constraints have been disabled and reenabled, but my log file isn't reporting anything related to the constraints.
BTW..I'm running Oracle 8.1.6.
Anyone have any ideas?
Click Here to Expand Forum to Full Width