Skip to main content
B
bueche
Participant
January 15, 2009
Question

Oracles table Partitions

  • January 15, 2009
  • 1 reply
  • 549 views
I have to create an app that front ends a database of network events. Users access this by time parameters. I take those parameters and determine the correct oracle partition to go to (for query speed purposes)., There are about 20 million rows in this database. I cant do anything without being able to specify partition. CF does not seem to work with the following:

select *
from reporting_db partition (p200901)

It does not seem to recognize "partition" as a keyword. And I need it to recognize the entire "partition (p200901)" as valid oracle sql. What am I missing?
This topic has been closed for replies.

1 reply

B
buecheAuthor
Participant
January 15, 2009
Well I guess I'm too tired or something. Its working now. It was not working from the flex cf wizard query dialog. But maybe I'm just working to many hours and it would have worked there too. Oh well.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices