Hi

I have a problem ,(But when i did it for first time i did not have any problem). This time when i load a table 's object data type columns from another table using INSERT INTO THE (SELE.... WHERE XXX = YYYY) I have the index for XXX & YYY
The above statement is a PL/SQL with cursors.
The data is huge !! I dont understand why now am facing this problem, (I am Truncating the table and reload it newly)..
When contachted DBA , he is telling he will export ,do segmentation for that table where its inserted and import it ?
I dont really understand !!!
Why is this happening ? is there any other way its possible to get rid of this ?
Arun