ora-00001 on analyze table list chained rows
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 6 Mar 2015 11:07:47 -0600
Message-ID: <CAJvnOJbP+QDtCVeiH5jXajsuRGbGXqATW_wRrhgSXMae8GYvgQ_at_mail.gmail.com>
Well I was running a basic DBA task on a table I suspect has row chaining, and i received an error:
Date: Fri, 6 Mar 2015 11:07:47 -0600
Message-ID: <CAJvnOJbP+QDtCVeiH5jXajsuRGbGXqATW_wRrhgSXMae8GYvgQ_at_mail.gmail.com>
Well I was running a basic DBA task on a table I suspect has row chaining, and i received an error:
ORA-00001, unique constraint violated. Has anyone seen this before?
the sequence of events was:
_at_?/rdbms/admin/utlchain.sql
analyze table me.mytable list chained rows;
then after about 40 minutes, I received
ora-00001 unique constraint violation.
Chained row table was empty after that.
oracle 11.2.0.3 EE on aix.
Anyone know the cause/fix?
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 06 2015 - 18:07:47 CET