Re: problem with dbms_redefinition

oops. oracle 19c on rhel 7.7.

On Tue, Dec 3, 2019 at 3:57 PM Andrew Kerber <andrew.kerber_at_gmail.com> 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.'
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l