RE: How to tell if you have stats on a object?

select * from dba_indexes
 where table_owner = '&owner'
minus
select * from dba_indexes_at_remote_db
 where table_owner = '&owner'
/

Make a database link called remote_db before issuing the above select.

> -----Original Message-----
> From: Browning, Alan [SMTP:abrowning_at_moorman.com]
> 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: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: abrowning_at_moorman.com
>
> 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: ListGuru_at_fatcity.com (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: rafiq9857_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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: abrowning_at_moorman.com
>
> 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: ListGuru_at_fatcity.com (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: Patrick.Elliott_at_bestbuy.com

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: ListGuru_at_fatcity.com (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).