I have been working on an utility that will generate and run multiple
dbms_redefinition sessions at the same time using the dbms_scheduler.
However, when I get the multiple sessions going, some of the jobs
invariably abort with this error stack:
ORA-02264: name already used by an existing constraint
ORA-06512: at "SYS.DBMS_REDEFINITION", line 2304
ORA-06512: at "SYS.DBMS_REDEFINITION", line 2304
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1773
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1655
ORA-06512: at "SYS.DBMS_REDEFINITION", line 451
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1645
ORA-06512: at "SYS.DBMS_REDEFINITION", line 2283
ORA-06512: at "SYS.DBMS_REDEFINITION", line 3475
ORA-06512: at "SYS.DBMS_REDEFINITION", line 6094
ORA-06512: at line 1
I checked all the table names and constraint names, and I dont see any that
are duplicate in my tables. Is there any way to figure out exactly what
constraint dbms_redefinition is complaining about? Note the stack only
mentions lines dbms_redefinition, not the SP I am using to call it, and of
course dbms_redefinition is wrapped. When I wait for the scheduler to
complete each job before starting the next one, the problem does not occur.
It only happens when multiple redefinition jobs are running at the same
time.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
