Home » SQL & PL/SQL » SQL & PL/SQL » Strange Error on Creating DB Table!!!
Strange Error on Creating DB Table!!! [message #243938] Mon, 11 June 2007 01:27 Go to next message
bbaz
Messages: 138
Registered: April 2007
Senior Member

Hi all,

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


DDL command:
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,
Baz

Re: Strange Error on Creating DB Table!!! [message #243951 is a reply to message #243938] Mon, 11 June 2007 01:55 Go to previous messageGo to next message
bbaz
Messages: 138
Registered: April 2007
Senior Member
I have added _SYSTEM_TRIG_ENABLED = FALSE parameter to my initialization file and restarted my DB and the error was resolved.

Does anyone know what is the drawback of Disabling this parameter??? Is this a bad practice???


I found that the following posting is helpful:
http://groups.google.com/group/comp.database.oracle/browse_thread/thread/107c3e26b68b93f9/b33dd0ac0aed0947?lnk=st&q=ORA-29540%3A+ class+oracle%2FCDC%2FPublishApi+does+not+exist&rnum=1&hl=en#b33dd0ac0aed0947

Your comments are appreciated.
Baz
Re: Strange Error on Creating DB Table!!! [message #243958 is a reply to message #243951] Mon, 11 June 2007 02:08 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't do that.
_system_trig_enabled can (and must) be set to false ONLY during patches and upgrades.
Investigate the reason of the error, maybe reinstall CDC...

Regards
Michel
Previous Topic: Incorrect Summation
Next Topic: How to convert column data into row
Goto Forum:
  


Current Time: Wed Dec 07 22:37:59 CST 2016

Total time taken to generate the page: 0.06971 seconds