Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Failure to select row count from a table partition

HouseofHungerJul 23 2010 — edited Jul 26 2010
Hi all,
I have a huge partitioned table with 117 million rows. The table is partitioned into 3 partitions. My problem is that I cannot select row counts from 2 of the partitions. The other partition does return a result.
On the two partitions for which I get no result, no error is being returned, the query just doesn't do anything.
The syntax I am using is the same in all cases.

Select count(1) from cmf partition (p1);

cmf - table name
p1 - partition name

there are 3 partitions p1, p2 and pcurrent - I can select from p2 but not from p1 and pcurrent.

also can i use hints when selecting from a partition as shown below:

select /*+ FULL PARALLEL(cmf,32)*/ count(1) from cmf partition (P1)

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2010
Added on Jul 23 2010
15 comments
5,129 views