HI,
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?


Urgent .
Please help

Regards
Shyla