Tim, Yes. my issue is associated with bug #2861165. Anyway I did not have any data for the partition in question. So I dropped the partition and recreated smaller partitions instead of SPLIT. Thanks again Sami On 4/30/05, Tim Gorman <tim@xxxxxxxxx> wrote: > Sami, >=20 > Bug #2861165 seems to be a "hit" on your symptoms and it indicates that a > workaround is to explicitly grant SELECT ANY TABLE to the user in questio= n; > apparently the problem is fixed in 10g. >=20 > -Tim -- //www.freelists.org/webpage/oracle-l