select * from dba_indexes
where table_owner = '&owner'
minus
select * from dba_indexes@remote_db
where table_owner = '&owner'
/
Make a database link called remote_db before issuing the above select.
> -----Original Message-----
> From: Browning, Alan [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 11:11 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to tell if you have stats on a object?
>
> Sorry typo ..... it is 7.3.4.5.0.
> Thanks for the correction.
>
> -----Original Message-----
> Sent: Monday, February 12, 2001 10:21 AM
> To: Multiple recipients of list ORACLE-L
>
>
> On quick question.
>
> Are you sure about database version 7.3.4.5.1 as according to oracle
> 7.3.4.5.0 is the final and no upgrade afterword for HP-UX 10.20.
> Regards
> Rafiq
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Mon, 12 Feb 2001 07:51:21 -0800
>
> HP-UX 10.20 running 7.3.4.5.1.
>
> I am trying to find out which indexes in one dbinstance
> are missing stats by comparing the one dbinstance
> to another and getting the difference.
>
> Any help would greatly be appreciated!
> Thanks in Advance.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Browning, Alan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Browning, Alan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Elliott, Patrick
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
