-
Title
Poster: Unexpected Oracle error: ORA-00928: missing SELECT keyword when replicating IOT overflow -
Description
Poster stopped due to ORA-00928: missing SELECT keyword.
Target event_log:
Info 2011-11-01 15:08:56.414873 29612 1 Poster exited with code=1, pid = 14173 (posting from {source sid}, queue {queue name}, to {target sid})
Error 2011-11-01 15:08:56.398197 14173 3 s:169 Poster: Unexpected Oracle error: ORA-00928: missing SELECT keyword. (object name: "OWNER"."SYS_IOT_OVER_<OBJECT_ID of the IOT/IOT PARTITION>") (posting from {source sid}, queue {queue name}, to {target sid}) [module opo]
Notice 2011-11-01 15:08:56.397593 14173 3 s:169 Poster: ORA-00928: missing SELECT keyword. (posting from {source sid}, queue {queue name}, to {target sid}) [module osp]
Info 2011-11-01 15:08:53.658353 14173 1 Poster launched, pid = 14173 (posting from {source sid}, queue {queue name}, to {target sid})
-
Cause
The IOT overflow table"OWNER"."SYS_IOT_OVER_<OBJECT_ID of the IOT/IOT PARTITION>" was being replicated in the cofig file
-
Resolution
Resolution :
Remove the IOT overflow table ("OWNER"."SYS_IOT_OVER_<OBJECT_ID of the IOT/IOT PARTITION>") from the config file
Workaround:
Disable object from replication on target:
1. sp_ctrl> set param SP_OPO_DISABLE_OBJECT_NUM={source OBJECT_ID of the IOT/IOT PARTITION}
2. sp_ctrl> stop post
3. sp_ctrl> start post