RE: Analyze only latest partition

From: Tatireddy, Shrinivas (MED, Keane) <Shrinivas.Tatireddy_at_med.ge.com>
Date: Wed, 28 Nov 2001 03:33:50 -0800
Message-ID: <F001.003CEB04.20011128031526@fatcity.com>

Hi Connor

Thanq for responding.

In dba_tab_partitions there is no such column like partition_id, and I would like to generate a list at schema level for each table.

That means, this script should capture the latest (last) partitions for each table (if it is partitioned) for a given schema.

Is there a way?

I tried with the following query. But there is some bug in that. It is not capturing the last partition (in a whole database):

select object_name,owner ,subobject_name from dba_objects where data_object_id in (select data_object_id from dba_objects where created in(select max(created) from dba_objects ) and data_object_id is not null);

Can anybody debug this.?

Thnx and Regards,

Srinivas

-----Original Message-----
Sent: Wednesday, November 28, 2001 7:30 AM To: Multiple recipients of list ORACLE-L

declare
  pname varchar2(100);
begin
  select partition_name
  into pname
  from user_tab_partitions
  where table_name = ...
  and partition_id =
    ( select max(partition_id)

      from user_tab_partitions
      where table_name = ... );

execute immediate 'analyze table ... partition ('||pname||')';
end;

or something similar to that..

hth
connor

"Tatireddy, Shrinivas (MED, Keane)" <Shrinivas.Tatireddy_at_med.ge.com> wrote: > Hi lists,
>
> Is there a script/command to analyze only the latest
> partition of my
> table. It has several partitions. For every month
> 1(one) partititon gets
> created to store that months data.
>
> Can anybody throw some script.?
>
> Thnx and Regards,
>
> Srinivas
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
> INET: Shrinivas.Tatireddy_at_med.ge.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).

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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: Tatireddy, Shrinivas (MED, Keane)
  INET: Shrinivas.Tatireddy_at_med.ge.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).

Received on Wed Nov 28 2001 - 05:33:50 CST