I am getting a strange error when I try to create a normal table with composite PK. The error is:
The following error has occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-29540: class oracle/CDC/PublishApi does not exist
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 0
ORA-06512: at line 4
CREATE TABLE A3_MVT (
LOC_CD VARCHAR2(10) NOT NULL,
MVT_MONO_CD VARCHAR2(7) NOT NULL,
MVT_ST NUMBER(2) NOT NULL,
MVT_MULTI_YN VARCHAR2(1) NOT NULL,
MVT_MULTI_CD VARCHAR2(7) NOT NULL,
CONSTRAINT PK_A3MVT_LOC_MONOCD PRIMARY KEY (LOC_CD,MVT_MONO_CD)
What might be the issue here? I read that it might be a problem with large_pool_size, system_trig_enabled parameters although no changes have been made on these parameters, or CDC (change data capture)!!!
Can someone help?
Thanks in advance,