Horje
oracle partition table row count Code Example
oracle partition table row count 
#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.



Sql

Related
mysql config slave Code Example mysql config slave Code Example
salesforce soql get parents without children Code Example salesforce soql get parents without children Code Example
unique index in mysql Code Example unique index in mysql Code Example
mysql select where field like in list Code Example mysql select where field like in list Code Example
Delete in SQL SERVER Code Example Delete in SQL SERVER Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje