Bulk gets the number of rows per child of the specified partition table!
Otherwise manual inquiry too troublesome!
---View the number of rows per child of a specified partition table
Create or replace procedure show_tabparcnt
(Partiton_tablename in User_tab_partitions.table_name%type)--Input parameters
As
TYPE cur is REF CURSOR return user_tab_partitions%rowtype; --Declaring the cursor type to ref
A cur; --Declaring a variable to be a REF CURSOR type
Re number;
Osname User_tab_partitions%rowtype;
Begin
Open a For select * from User_tab_partitions where Table_name=upper (Partiton_tablename);
Loop
Fetch a into osname;
Exit when a% NotFound;
Execute immediate ' SELECT COUNT (*) from ' | | Upper (Partiton_tablename) | | ' partition (' | | osname.partition_name| | ') '
into re;
Dbms_output.put_line (' User partition table ' | | Upper (Partiton_tablename) | | The Zoning ' | | osname.partition_name| | ' The number of rows is: ' | | re| | '; ');
End Loop;
Close A;
End
/
exec show_tabparcnt (' Orderlog ');
Back to the column page: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/