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:

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-l
Received on Fri Mar 06 2015 - 18:07:47 CET

Original text of this message