using a partition in a query.

[ehspacl]

Dear All,

i am trying to select from a partition called PART1:-

Select * from config (PART1) where config_value='Y';

But keep getting error ora-00933.
I have copied the syntax from the book and it doesn't work.

Any ideas?

2 partitions are setup on the table for the config_value column less than m% and maxvalues. called PART1 and PART2.

Trying to return all rows in partition PART1 and thathave a config_value='Y'. Is this possible?

Many thanks in advance