Re: analyze_schema on remote database?
From: Mladen Gogala <no_at_email.here.invalid>
Date: Fri, 5 Aug 2011 17:13:13 +0000 (UTC)
Message-ID: <pan.2011.08.05.17.13.12_at_email.here.invalid>
On Fri, 05 Aug 2011 05:24:46 -0700, blindsey wrote:
Date: Fri, 5 Aug 2011 17:13:13 +0000 (UTC)
Message-ID: <pan.2011.08.05.17.13.12_at_email.here.invalid>
On Fri, 05 Aug 2011 05:24:46 -0700, blindsey wrote:
> (This in Oracle 11g.)
>
> I'm trying to run DBMS_UTILITY.ANALYZE_SCHEMA on a database through a
> link.
Why in the world would you do DBMS_UTILITY.ANALYZE_SCHEMA and not DBMS_STATS.GATHER_SCHEMA_STATS on 11G?
>
> I'm connected as USER01/PW01_at_LINK01.
>
> First, I tried DBMS_UTILITY.ANALYZE_SCHEMA ('USER01','COMPUTE');
>
> I get "user 'USER01' does not exist.
>
> Same thing if I substitute 'USER01_at_LINK01' for 'USER01'.
>
> Can I do this? How?
You cannot. You have to log in the database and run stats locally.
-- http://mgogala.byethost5.comReceived on Fri Aug 05 2011 - 12:13:13 CDT