Okay lets start again assuming I never asked the previous question.

This is the query that I got when I selected table_name, Partition_name, tablespace_name from dba_tab_partition

TABLE_NAME PARTITION_NAME TABLESPACE_NAME
--------------- --------------------- ----------------------
SALES SALES_JAN2000 SALES_TABLESPACE


How do I count the number of rows in partition sales_jan2000?

NOTE: I am running 8.I.5 on Sun solaris

[Edited by mybear on 02-01-2001 at 07:55 AM]