constraint: disable validate returns error while trying to load data
SmoothKJul 1 2010 — edited Jul 5 2010Hi,
I may be missing something but this is what I'm facing:
Table ttab has a primary key, let say ttab_pk, that I modified using this command: alter table ttab modify constraint ttab_pk disable validate.
I thought I would be able to load new data with SQLLoader without any problem (sqlldr userid=myusr/mypwd control=myctl.ctl direct=TRUE), but I keep having this msg:
SQL*Loader-951: Error calling once/load initialization
ORA-02373: Error parsing insert statement for table MYSCHEMA.TTAB.
ORA-25128: No insert/update/delete on table with constraint (MYSCHEMA.TTAB_PK) disabled and validated
In what config the "disable validate" really work ?
Thank a lot for any help.