analyze_schema on remote database?
From: blindsey <blindsey_at_dsicdi.com>
Date: Fri, 5 Aug 2011 05:24:46 -0700 (PDT)
Message-ID: <7fa520d5-5d57-481d-b3f7-285f35fa7f4b_at_dp9g2000vbb.googlegroups.com>
(This in Oracle 11g.)
Date: Fri, 5 Aug 2011 05:24:46 -0700 (PDT)
Message-ID: <7fa520d5-5d57-481d-b3f7-285f35fa7f4b_at_dp9g2000vbb.googlegroups.com>
(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.
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? Received on Fri Aug 05 2011 - 07:24:46 CDT