problem with dbms_redefinition

From: Andrew Kerber <>
Date: Tue, 3 Dec 2019 15:57:07 -0600
Message-ID: <>

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.'

Received on Tue Dec 03 2019 - 22:57:07 CET

Original text of this message