I am newbie to oracle sql loader. My requirement is to collect data file from user and insert to the table using sql loader.
I run SQL Loader it was working file in very first time. Records are inserted into the database.
After that I tried the same thing i will get the below error
ORA-26026: unique index SELVA.PK_TEMP_TABLE initially in unusable state
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Best Answer
You have to rebuild or skip the index
SELVA.PK_TEMP_TABLE
.