Re: Table Partition Count
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 25 Nov 2009 14:03:49 -0000
Message-ID: <bPednbkvq-bZpJDWnZ2dnUVZ8midnZ2d_at_bt.com>
Date: Wed, 25 Nov 2009 14:03:49 -0000
Message-ID: <bPednbkvq-bZpJDWnZ2dnUVZ8midnZ2d_at_bt.com>
"raja" <dextersunil_at_gmail.com> wrote in message
news:506a12f9-9aab-4108-81f6-59f34f6f7ac5_at_x25g2000prf.googlegroups.com...
> Hi,
>
> I have a table T1.
> I have 5 partitions in that table, say : PART1, PART2, PART3, PART4,
> PART5.
>
> I need to take individual row count for these 5 partitions present in
> the table T1.
> How can i do that ?
>
> Please help.
>
> With Regards,
> Raja.
What version of Oracle ?
What do you want your output to look like ?
How generic do you want the query to be ?
How often do you want to do it ?
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Wed Nov 25 2009 - 08:03:49 CST