After issue a "create profile DDL" on source, and then issue "alter user add profile", Post was stopped on target with the error below:
Create / Alter profile is not supported by SharePlex.
The create profile "PROFILE_TEST" was not replicated to the target, then the "alter user add profile" got ORA-02380: error on target because couldn't find the profile on target database.
You can either manually fix the condition on target that causes the DDL to fail or to skip the problematic DDL.
1. Manually fix the problematic DDL that failed and then execute the DDL manually on target database through sqlplus.
sp_ctrl> start post
Or
2- Go to target where the Post stopped due to error and set the below parameter to skip the problematic DDL
sp_ctrl>set param SP_OPO_STOP_ON_DDL_ERR 0
Post should skip this problematic DDL and move on.
To reset this parameter,
sp_ctrl>reset param SP_OPO_STOP_ON_DDL_ERR
