Error ORA-00001-Unique constraint

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 18 Jun 2009 2:16 pm

Expensive, good afternoon!

Please, someone recognizes this error ORA-00001: unique constraint (PERFSTAT.STATS $ SQL_SUMMARY_PK) violated?

I'vê checked the Traces and the only thing that appears is the above error.

This is a package body of oracle that performs a cleaning of data from a table, but within this package the same calls several procedures.

Note: it was raised only the Traces (2268 and 4224) and 2 contained the same information.

Thank you in advance!!
cleber
Location: SP

Cléberson da Silva
DBA Oracle Jr.

Poston Thu, 18 Jun 2009 2:47 pm

Good afternoon this error refers to a primary key being raped.
In your case as you said that the package makes a clean check if she's not deleting a record that has other records referring to it, in case it would be the SQL_SUMMARY_PK if you cannot, please post in the forum.
SergioLBJr
Location: Parobé - RS

Sérgio Luiz Bonemberger Junior
Programador Junior
Parobé RS

[]s

Poston Thu, 18 Jun 2009 2:52 pm

Thanks Brow Thanks!!

So is this package will medical reports day before the current day.

But I do not understand: what kind of key it is duplicating being that he deletes instead of insert??

Abs
cleber
Location: SP

Cléberson da Silva
DBA Oracle Jr.

Poston Thu, 18 Jun 2009 3:09 pm

Why don't you see what this constraint makes?

Trace will not help you ...

Searches the all_constraints or even, in sql navigator, hold control and click the object you want to view your structure ... There has everything you need!

the reason for the error is single, she's being doubled.
RodrigoValentim
Location: Salvador - BA

Rodrigo Valentim
Analista de Sistemas
Oracle Developer

Campanha: Faça uma pesquisa antes de perguntar!!!

Poston Thu, 18 Jun 2009 3:31 pm

valeu brow ...

I checked the ALL_CONS_COLUMNS and found the table on which the constraint PK.

Please, answer me one thing: the PERFSTAT user is a user of the Oracle himself and what he does?

Vlw!
cleber
Location: SP

Cléberson da Silva
DBA Oracle Jr.

Poston Thu, 18 Jun 2009 4:09 pm

PERFSTAT/PERFSTAT Oracle Statistics Package (STATSPACK) that supersedes UTLBSTAT/UTLESTAT
RodrigoValentim
Location: Salvador - BA

Rodrigo Valentim
Analista de Sistemas
Oracle Developer

Campanha: Faça uma pesquisa antes de perguntar!!!


  • See also
    Replies
    Views
    Last Post


      Return to SQL

      Who is online

      Users browsing this forum: No registered users and 8 guests