problem with dbms_redefinition
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 3 Dec 2019 15:57:07 -0600
Message-ID: <CAJvnOJYss0xO4JNAN-fT8XkyEZrJBwccsGDE_kbqY-RX2oFX7w_at_mail.gmail.com>
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:
Date: Tue, 3 Dec 2019 15:57:07 -0600
Message-ID: <CAJvnOJYss0xO4JNAN-fT8XkyEZrJBwccsGDE_kbqY-RX2oFX7w_at_mail.gmail.com>
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.'-- http://www.freelists.org/webpage/oracle-l Received on Tue Dec 03 2019 - 22:57:07 CET