Dear Agasimani,

Thank you for your timely and usefull suggestion. I could locate two LOB indexes in those tablespace and could be located by querying dba_segments with your query. My mind was completely locked and to be frank, I queried all other things except dba_segments. I finally recreated those two tables containing lob indexes to the tablespace required.

Thanks again and also cheers to akhadar.

Regards,

K.Diwakar