When running ora_cleansp the following error is thrown.
SQL> update shareplex_actid set actid=0, seqno=0, offset=0, instance_name = '', host_name = '', ab_flag = 0, que_seq_no_1 = 0, que_seq_no_2 = 0, sp_thread_msg_seq = 0, sp_thread_msg_seq_wrap = 0, command = '', activation_flag = 0
*
ERROR at line 1:
ORA-00904: "ACTIVATION_FLAG": invalid identifier
You are trying to run ora_cleansp for version 5.0 against a shareplex for oracle 4.x tables.
shareplex_actid for version 5
SQL> desc shareplex_actid
Name Null? Type
----------------------------------------- -------- ----------------------------
ACTID NUMBER
SEQNO NUMBER
OFFSET NUMBER
INSTANCE_NAME VARCHAR2(16)
HOST_NAME VARCHAR2(64)
AB_FLAG NUMBER
QUE_SEQ_NO_1 NUMBER
QUE_SEQ_NO_2 NUMBER
SP_THREAD_MSG_SEQ NUMBER
SP_THREAD_MSG_SEQ_WRAP NUMBER
COMMAND VARCHAR2(255)
ACTIVATION_FLAG NUMBER
SQL>
shareplex_acid for version 4.5.x looks like
SQL> desc shareplex_actid;
Name Null? Type
----------------------------------------- -------- ----------------------------
ACTID NUMBER
SEQNO NUMBER
OFFSET NUMBER
INSTANCE_NAME VARCHAR2(16)
HOST_NAME VARCHAR2(64)
AB_FLAG NUMBER
QUE_SEQ_NO_1 NUMBER
QUE_SEQ_NO_2 NUMBER
COMMAND VARCHAR2(255)
Resolution:
Run the correct ora_cleansp
