The Load Data Warehouse (DWH) full is failing with error: ORA-01735: invalid ALTER TABLE option
Full error below:ClarityDB - isOracle? - An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
FOR I IN (SELECT TABLE_NAME, CONSTRAINT_NAME
FROM USER_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'P'
AND STATUS = 'DISABLED')
LOOP
EXECUTE IMMEDIATE 'ALTER TABLE ' ||I.TABLE_NAME|| ' ENABLE CONSTRAINT ' ||I.CONSTRAINT_NAME || ' EXCEPTIONS INTO DWH_FK_PK_EXCEPTIONS';
END LOOP I;
END;
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 7
Release : All
Rebuild the DWH. See steps at When to rebuild the Data Warehouse (DWH) database