Re: Table Partition Count
Date: Wed, 25 Nov 2009 14:03:49 -0000
"raja" <dextersunil_at_gmail.com> wrote in message
> I have a table T1.
> I have 5 partitions in that table, say : PART1, PART2, PART3, PART4,
> 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,
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