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