then check the docs for indexes on range partioned tables..
---
Good Luck..Subodh Deshpande
===============================================
Experience Is Knowledge
Wisdom Is Philosophy
==============================================
--------- Original Message ---------
DATE: Tue, 20 Apr 2004 18:55:52
From: "Wilkinson, Marcus" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed]
>Sorry the table are range partitioned, could that have an impact?
>
>Thanks
>
>
>
>
____________________________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Oracle LazyDBA home page