Re: Table Partition Count

From: raja <dextersunil_at_gmail.com>
Date: Fri, 27 Nov 2009 11:28:09 -0800 (PST)
Message-ID: <2679cd5a-d56e-44f0-9a39-93253fbcfbf6_at_u1g2000pre.googlegroups.com>

Matthew,
Thanks a lot. Let me check this out and if i have doubts, i will get back to you

Jonathan Lewis,
Sorry for late reply.

1. What version of Oracle ? 10gR1 ( Datawarehousing )
2. What do you want your output to look like ? Owner, table_name, partition_name, count me, table1, part1, 1001 me, table1, part2, 99 me, table1, part3, 143 me, table2, part1, 786 me, table2, part2, 123
3. How generic do you want the query to be ? Sorry, cant understand.
4. How often do you want to do it ? Less frequent, but though if there is a query, thats would help a lot for testing a scenario.

Thanks in Advance.

With Regards,
Raja. Received on Fri Nov 27 2009 - 13:28:09 CST