(This in Oracle 11g.)

I'm trying to run DBMS_UTILITY.ANALYZE_SCHEMA on a database through a
link.

I'm connected as USER01/PW01 (AT) LINK01 (DOT)

First, I tried DBMS_UTILITY.ANALYZE_SCHEMA ('USER01','COMPUTE');

I get "user 'USER01' does not exist.

Same thing if I substitute 'USER01@LINK01' for 'USER01'.

Can I do this? How?

On Fri, 05 Aug 2011 05:24:46 -0700, blindsey wrote:


Why in the world would you do DBMS_UTILITY.ANALYZE_SCHEMA and not
DBMS_STATS.GATHER_SCHEMA_STATS on 11G?


You cannot. You have to log in the database and run stats locally.





--
http://mgogala.byethost5.com

First try running it locally while connected as same user that was
used in the db link.
Once you get it working try executing the same thing remotely.