| RENABLE DISABLED_CONSTRAINTS [message #70983] |
Thu, 22 August 2002 14:30  |
Chris Lomvardias
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
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?
Chris
|
|
|
|
|
|
| Re: REENABLE DISABLED_CONSTRAINTS [message #70989 is a reply to message #70983] |
Fri, 23 August 2002 06:10  |
Chris Lomvardias
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
I'm not having any problems with the load itself, but rather that the constraints are not being reenabled despite including the "REENABLE" clause. Also, the docs indicate that log should indicate which constraints were disabled and reenabled during the load and this is not showing up either.
Chris
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
