Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ORA-31403: change table  already contains a column

Posted on 2012-08-16
2
Medium Priority
?
644 Views
Last Modified: 2012-08-16
Hi,

Could you please help me to resolve this


SQL> begin
  2  DBMS_CDC_PUBLISH.ALTER_CHANGE_TABLE (OWNER =>'TESTCDCPUB',
  3  CHANGE_TABLE_NAME =>'TEST_HOLD_REASON_CT',
  4  OPERATION =>'ADD',
  5  COLUMN_LIST =>'CDC_FLAG VARCHAR2(50)',
  6  RS_ID =>'N',
  7  ROW_ID =>'N',
  8  USER_ID =>'N',
  9  TIMESTAMP =>'Y',
 10  OBJECT_ID =>'N',
 11  SOURCE_COLMAP =>'N',
 12  TARGET_COLMAP =>'N');
 13  end;
 14  /
begin
*
ERROR at line 1:
ORA-31403: change table  already contains a column
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 633
ORA-06512: at line 2
0
Comment
Question by:ajaybelde
2 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 38302365
If you check out that error on: http://www.ora00600.com/scripts/changedatacapture/change_table_add_column.html

This error is because when the change table was originally created the values for rs_id, row_id, user_id, timestamp, object_id, source_colmap and target_colmap were already specified. In order to prevent this error change all the values for the aforementioned columns to ‘n’ and it should run through without error.
0
 

Author Comment

by:ajaybelde
ID: 38302400
Thank You..It worked fine with TIMESTAMP =>'N'.

Thanks again!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question