Partition Check
Hi All,
Oracle 11gR2.
There are few partitioned tables in a database. Partitioned by range on date & time. Created daily.
How to check through sql query;
1.List of partitioned tables and their size
2. List of all tables along with partition tables and size
3. size of each partition,
4. size of partition for a range of years (say 2001 to 2008)
Thanks.