Skip to Main Content

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!

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

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,827 views