Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01502

user4421692Oct 29 2012 — edited Oct 30 2012

Hi,

I have this table

drop table IP_NUM cascade constraints;
create table IP_Site(
ID NUMBER NOT NULL,
Sigla VARCHAR2(10) ,
UserIns VARCHAR2(10) ,
UserUpd VARCHAR2(10) ,
Note VARCHAR2(100) ,
Provincia VARCHAR2(2) ,
ID_Rete VARCHAR2(50) ,
DateIns DATE ,
DateUpd DATE)
TABLESPACE &tspace;

ALTER TABLE IP_Site
add CONSTRAINT IP_Site_pk PRIMARY KEY (ID_Site);

I check the index

SELECT * from USER_INDEXES WHERE INDEX_NAME ='ID_PK'

I see the status set as 'VALIDATE' .

I have a sqlldr file like this:

1/|API/|/|/|/|MI/|OPEN/|2004-09-13 00:00:00/|
1/|API/|/|/|/|MI/|OPEN/|2004-09-13 00:00:00/|
2/|API/|/|/|/|MI/|OPEN/|2004-09-13 00:00:00/|

When I run the sqlldr, I have 3 record inside the table, and when I try some insert, I have this error:

ORA-01502: index 'TIP_WORKING.ID_PK' or partition of such index is in unusable state.

When I check the index

SELECT * from USER_INDEXES WHERE INDEX_NAME ='ID_PK'

I see the status set as 'UNUSABLE' .

I have 2 question:

1 - Is it possibile that sqlldr can violate a pk constraint?
2 - How I can resolve this problem?

Best regards and thanks for all