In this page you can find my published video tutorials list.
1. How we can install RHEL4 using Wmware
For watch video click here
2. How to install Oracle 11gR2 on Windows 7 using Wmware
For watch video click here
In this page you can find my published video tutorials list.
1. How we can install RHEL4 using Wmware
For watch video click here
2. How to install Oracle 11gR2 on Windows 7 using Wmware
For watch video click here
i had an error earlier today when i was carrying out health check on my database. ora -20000 and i tried to rebuild online, but it didnt work, and it came up with a message about duplicity of the index file and i searched to locate if that was true, but i tried to solve the problem by searching for multiple index with the same name, but there wasnt.
what can i do please
Hi;
Did you try to drop index and recreate index again?What is exact error message?
Errors in file /oracle/admin/pameEric/bdump/pameeric_j000_5867.trc:
ORA-20000: index “PAMEMNC”.”IMPORTNWBA7_UK0″ or partition of such index is in unusable state
Tue Jan 3 22:40:36 2012
Thread 1 advanced to log sequence 15793 (LGWR switch)
Current log# 1 seq# 15793 mem# 0: /hawk_pamme_log/pameEric/redo01a.pameEric
Current log# 1 seq# 15793 mem# 1: /hawk_pamme_log/pameEric/redo01b.pameEric
Tue Jan 3 22:01:48 2012
Errors in file /oracle/admin/pameHuaw/bdump/pamehuaw_j000_5869.trc:
ORA-20000: index “PAMEMNC”.”IMPORTNWBA1_UK0″ or partition of such index is in unusable state
and i tried rebuilding the index online by
SQL> ALTER INDEX pamemnc.IMPORTNWBA1_UK0 rebuild online;
ALTER INDEX pamemnc.IMPORTNWBA1_UK0 rebuild online
*
but returned the error
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
what should i do now please
Hi;
Please see:
ORA-01452: Cannot Create Unique Index; Duplicate Keys Found [ID 332494.1]
OERR: ORA 1452 “cannot CREATE UNIQUE INDEX; duplicate keys found” [ID 18855.1]
Also see:
Script: Deleting Duplicate Rows from a Table [ID 31413.1]
- Script find duplicate rows
select
–Enter name(s) of column(s) which should be unique
&&c
from
– Enter name of table with duplicate rows
&&t
where rowid not in (select min(rowid) from &&t group by &&c)