 | |
| ORA-00001 | | ORA-00001: | unique constraint (string.string) violated | | Cause: | An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. | | Action: | Either remove the unique restriction or do not insert the key. |
|
|
| Posts about ORA-00001 | | I 've had similar problems in 10.2.0.2 recently with a known bug
(Metalink notes 5103126 4618615 & 5130698) causing slowness with the
following recursive query
select c.name u.name from con$ c cdeOn 4/12/06 Paul Drake <bdbafh@(protected) > wrote
>
> 10.1.0.4 10.1.0.4 patch 10 standard edition
> w2k adv svr sp4
>
> I 'm wondering if anyone has seen this type of error before?
>
> Had contention o10.1.0.4 10.1.0.4 patch 10 standard edition
w2k adv svr sp4
I 'm wondering if anyone has seen this type of error before?
Had contention on a single tempfile in a temp tablespace.
Only one tempfile o
this just reminds me of an example I worked on a while ago with Diana Lorentz
for the SQL Reference where two columns are involved
see
http //download-uk.oracle.com/docs/cd/B19306_01/server.102/bHow about this
SQL > create table test (id1 number(10) id2 number(10))
Table created.
SQL > create unique index test_ind on test (case when id2 is not null
then to_char(id1)|| '- '||to_char(id2) endI am attempting full export from DB1 Orcl 9.2.0.1 on Win - > full
import into the empty pre-created DB2 9.2.0.7 on different Win
system using this (DOS batch) command
%IMPUTIL% %IMPORTER%/%IMPORTEOn 9/12/05 Allen Brandon <Brandon.Allen@(protected) > wrote
> "write consistency " does not show up in the 'transaction rollbacks '
statistic. So I 've come
> to believe that the high 'transaction roDoes anyone know how Oracle 's trace analyzer should be configured in
RAC. It works fine in single instance but spits out the following
message when I try to run it in a RAC instance.
exec trca$i.tracThe database will not care if you set the clock back one hour. You will
need to avoid running a point in time recovery that uses a time within
that hour but you can run a point in time recovery usiHi again
Can any show me how to catch error in triggers ?
Let say my system have tis error
ERROR at line 1
ORA-00001 unique constraint (PNT.ID_PK) violate
When i try to insert id which exHey all
Anyone here using Oracle 's Ultra Search? The MetaLink forum is
apparently unmonitored and even Google hasn 't helped much. I 've got
some outstanding issues (at least three) on our 1It would help us to have the whole trigger.
It seems that you are using the trigger to prevent duplicates. Can you not
use a unique constraint for that task trapping the
ORA-00001/DUP_VAL_ON_INDI tried this and it worked.
ODMDB SQL > create table test(id number status varchar2(8))
Table created.
ODMDB SQL > create unique index foo on test (case when status 'Current '
then id else n |
|
| Oracle Database Server Error Codes | |
|