oops. oracle 19c on rhel 7.7.
On Tue, Dec 3, 2019 at 3:57 PM Andrew Kerber <andrew.kerber@xxxxxxxxx>
wrote:
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.'
