|
View previous topic :: View next topic
|
| Author |
Message |
theone1987
New User
Joined: 14 Sep 2009
Posts: 60
Location: Milan
|
|
|
|
Hello everyone,
due to an abend during a load, the indexes of the table remained in REBUILD PENDING.
if I try to do the REBUILD INDEX , it give me as an error "duplicate keys"
how can I fix the index?
thank you very much.
thank you
theone |
|
| Back to top |
|
 |
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| Trying dropping and re-creating the index. |
|
| Back to top |
|
|
theone1987
New User
Joined: 14 Sep 2009
Posts: 60
Location: Milan
|
|
|
|
| Akatsukami wrote: |
| Trying dropping and re-creating the index. |
i can't. I have not the privilege. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Then you need to involve the dba. . . |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
How would dropping and recreating an index solve duplicate keys?
If load replace : remove duplicates from input and reload. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Guy,
As i suspect there is more to this, i mentioned involving the dba. . .  |
|
| Back to top |
|
|
theone1987
New User
Joined: 14 Sep 2009
Posts: 60
Location: Milan
|
|
|
|
i've done drop and create.
thank you. |
|
| Back to top |
|
|
|
|
