Oracle GoldenGate Error Messages

OGG-00509

CREATE/ALTER USER with IDENTIFIED clause encountered, but no DDLOPTIONS DEFAULTUSERPASSWORD specified


Cause

A CREATE or ALTER USER with an IDENTIFIED BY clause was processed. The Extract parameter file contains DDLOPTIONS with the NOREPLICATEPASSWORD option to prevent the source password from being propagated, but the Replicat parameter file does not contain DDLOPTIONS with DEFAULTUSERPASSWORD to specify an alternate password for the target IDENTIFIED BY clause.


Action

Add the DDLOPTIONS with DEFAULTUSERPASSWORD.