Exadata General (MOSC)

MOSC Banner

how to solve ORA-31421: change table does not exist

edited Jan 4, 2024 7:00PM in Exadata General (MOSC) 2 commentsAnswered

Oracle EXADATA

Oracle database 11g

I have created oracle CDC in my test environment.

Even though I have faced below error while I created change table, table wa created as normal table in the db. Actually, This table [cdcpub.trans_ct] should be in change_tables. But there is no table in change_tables; how to solve it? Thanks in advance.


BEGIN

  DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE(

  owner             => 'cdcpub',

  change_table_name => 'TRANS_CT',

  change_set_name   => 'CHANGESET_SIT',

  source_schema     => 'MYUSERSIT',

  source_table      => 'TRANS',

  column_type_list  => 'ID NUMBER(18), CREATED TIMESTAMP(3), TYPE_ NVARCHAR2(24), LAST_MODIFIED TIMESTAMP(3),STATE NUMBER(5)',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center