Re: DBMS_REDEFINITION error ORA-01442 - how to proceed?
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 19 Dec 2012 15:52:44 -0500
Message-ID: <CAMVw97LWY3-tdCPCtQisdNSCXq14Q4bqX_20JN0gMupB7z+E4g_at_mail.gmail.com>
You can do dbms_redefinition.copy_table_dependents with "ignore_errors => true", it should transfer whatever it can, num_errors will have how many errors it faced and you can review that after, that should go over the error you've got.
Date: Wed, 19 Dec 2012 15:52:44 -0500
Message-ID: <CAMVw97LWY3-tdCPCtQisdNSCXq14Q4bqX_20JN0gMupB7z+E4g_at_mail.gmail.com>
You can do dbms_redefinition.copy_table_dependents with "ignore_errors => true", it should transfer whatever it can, num_errors will have how many errors it faced and you can review that after, that should go over the error you've got.
If you want to undo, you can try dbms_redefinition.abort_redef_table.
On Wed, Dec 19, 2012 at 1:15 PM, <Christopher.Taylor2_at_parallon.net> wrote:
> So I received the following error moving a non-partitioned table to a partitioned one and now I have 2 tables in various states:
> ERROR at line 1:
> ORA-01442: column to be modified to NOT NULL is already NOT NULL
> ORA-06512: at "SYS.DBMS_REDEFINITION", line 984
> ORA-06512: at "SYS.DBMS_REDEFINITION", line 1727
> ORA-06512: at line 2
>
-- Alex Fatkulin, http://afatkulin.blogspot.com Enkitec, http://www.enkitec.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 19 2012 - 21:52:44 CET