-
Title
Does SharePlex support create / alter Profile DDL? -
Description
After issue a "create profile DDL" on source, and then issue "alter user add profile", Post was stopped on target with the error below:
Poster exit on ddl error due to ORA-02380: profile PROFILE_TEST does not exist. on alter user MY_USER profile PROFILE_TEST (posting from ORA11GR2, queue alvsupu16, to ORA11GR2) [module opo] -
Cause
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.
-
Resolution
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