When a user with an expired password logs in and is forced to change their password on the source it is not replicated to target.
PROBLEM:
When a user with an expired password logs in and is forced to change their password a 9i DDL record is not generated in the redo log. Therefore Shareplex will not be able to replicate this command.
WORKAROUND:
Manually issuing an ALTER USER to explicitly change a user's password or expire generates a 9i DDL redo log message and is replicated.
