You could ENABLE .... NOVALIDATE if you are 100% sure that the data was validared during ETL. This is somewhere in the Datawarehousing Guide in the documentation. Hemant K Chitale sent from my smartphone On 21 Apr 2011 03:04, "Joe Smith" <joe_dba@xxxxxxxxxxx> wrote: > After a direct path load. Enable FK cons with: > > Alter table enable con con_name exceptions into exceptions table > > > Thanks >