ORA-02264: name already used by an existing constraint
Hi all,
I am encountering a strange problem during executing the Beginddl on a versioned table. I have been imported the full export from 10.2.0.2, OWM 10.2.0.3.1 on linux to oracle 10.2.0.4 OWM 10.2.0.4.3. on IBM AIX 5.3.7. I did not have such an issue on 10.2.0.2 on Linux.
Right after the import completed, I tried to create indexes on versioned tables. But when I executed the Beginddl on a versioned enabled table for the first time, it generated some check constraints eg. SYS_C00xxx_LTS . The next time when I tried to execute the Begindd again, I received the following errors:
BEGIN dbms_wm.beginddl('TOPO'); END;
*
ERROR at line 1:
ORA-02264: name already used by an existing constraint
ORA-06512: at "WMSYS.LT", line 12138
ORA-06512: at line 1
Oracle recommended to rename and drop these constraints through AlterversionTable procedure. I have renamed them without any problem. But, in order to drop them I need to execute the Beginddl again. As soon as I run the Beginddl, the same constraints generated again. I have no clue how to deal with such a problem. So far I have not got any definite solution from Oracle. They are in the process of duplicating the problem in their environment. Your help on this issue will be highly appreciate it.
Thanks
MK