I think the privilege is analyze any. On Fri, Jul 4, 2008 at 12:53 PM, GBA-DBA <gba.oraclel@xxxxxxxxx> wrote: > List, > > Is it possible to collect stats from schema A for an object in schema B? > Are there any specific requirements or privileges to do it? > > I'm using oracle 10g r1 > > Thanks for your time. > > -- > Regards > GBA > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'