thanks for reply. my oracle is Enterprise Edition Release 10.1.0.4.0
I can choose any type of partitioning whichever is applicable for best performance as i am the one to do so.. or suggest me.