Breaking News: Grepper is joining You.com. Read the official announcement!

oracle partition table row count

Outrageous Okapi answered on March 9, 2022 Popularity 3/10 Helpfulness 5/10

answer oracle partition table row count

oracle partition table row count

Comment

#Run this to generate a set of selects for each partition

SELECT 'SELECT ' || chr(39) || partition_Name || chr(39) || ', count(*) 
        FROM ' ||table_name ||' partition (' || partition_name || 
        ') UNION ALL ' as test 
FROM all_tab_partitions 
WHERE table_Name = 'Table_1';
#Results in something like:

SELECT 'P1', count(*) FROM Table_1 partition (P1) UNION ALL 
SELECT 'P2', count(*) FROM Table_1 partition (P2) UNION ALL 
SELECT 'P3', count(*) FROM Table_1 partition (P3) UNION ALL 
SELECT 'P4', count(*) FROM Table_1 partition (P4) UNION ALL 
SELECT 'P5', count(*) FROM Table_1 partition (P5) UNION ALL
#Copy and paste results removing last union all and then run.

Popularity 3/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: count oracle partition row sql

Link to this answer
Share Copy Link

Contributed on Mar 09 2022

Outrageous Okapi

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

oracle partition table row count

Contents

More Related Answers

oracle partition table row count

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.