We have a table partitioned on a date but unfortunately when the data was loaded into that table the field was inserted with SYSDATE and hance all the data are put in one partition (depending on the sysdate ) . Now i can identify the data thru a number which will be there in a status table . But alread the table has Millions of data (say one partition) now instead of going thru the full scan (partition scan) i want to restrict the one and only partition . How do i specify the partition name in my sql statement and i want to index that partition alone as its one -time job. So is there any way that can be done?
Generally when i do an insert into a table it happens fast say for 2 lakh record it takes three mins. Whereas when i do an update it takes more than 30 minutes . the PCTFREE is 20 and the PCTUSED is 80 for that table and partitioned.
Can anyone suggest me what could be the reason for that?