Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01502 when skip_unusable_indexes=TRUE

JackKMar 6 2014 — edited Mar 7 2014

Hi,

I have some tables (call them "T-tables") with several million rows of data. Once a week I need to insert new data to that tables. The tables have some primary/unique indexes.

This is the case (once a week):

1. I am doing an import of a plan-text file (about 500MB) into my main tables.

2. I need to make a copy of the imported data from main tables to T-tables.

At the moment T-tables contains 100 of imported files. At the beginning (there were no more than 5 files in T-tables) the operation of coping took 2-3 minutes to complete. Now it takes 2 hours. I thing it's because index maintanance during inserting data to T-tables.

So I made a try and make all T-table's indexes unusable before start of copy operation and execute:

ALTER SESSION SET skip_unusable_indexes = TRUE;

to prevent ORA-01502 error. However, during copy I got ORA-01502 error anyway. Why is this happened???

Thank in advance,

Jacek

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 4 2014
Added on Mar 6 2014
15 comments
21,683 views