Oracles "Partition" keyword
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
Oracles "Partition" keyword
by bradbueche
::
Rate this Message:
I need to query a very large oracle database of network event traffic. I cant really do any sort of efficient query unless I can specifiy partition:
SELECT * FROM reporter_db PARTITION (P200901) CF doesnt seem to recognize the "PARTITION (P200901)" Is there some special syntax I have to use to get it to recognize this? thanks brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3172 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
RE: Oracles "Partition" keyword
by Brad Comer
::
Rate this Message:
Since your trying to do it with SLOW ColdFusion, I would recommend you move
it into a Oracle Stored procedure and run it that way then CF doesn't play any part in the actual querying of the data. My 2 cents... Brad -----Original Message----- From: Brad Bueche [mailto:brad@...] Sent: Thursday, January 15, 2009 9:31 AM To: sql Subject: Oracles "Partition" keyword I need to query a very large oracle database of network event traffic. I cant really do any sort of efficient query unless I can specifiy partition: SELECT * FROM reporter_db PARTITION (P200901) CF doesnt seem to recognize the "PARTITION (P200901)" Is there some special syntax I have to use to get it to recognize this? thanks brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3173 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
Re: Oracles "Partition" keyword
by James Holmes-3
::
Rate this Message:
Is reporter_db a table or schema name?
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/16 Brad Bueche <brad@...>: > I need to query a very large oracle database of network event traffic. I cant really do any sort of efficient query unless I can specifiy partition: > > SELECT * > FROM reporter_db PARTITION (P200901) > > CF doesnt seem to recognize the "PARTITION (P200901)" > > Is there some special syntax I have to use to get it to recognize this? > > thanks > brad > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3174 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
|
|
RE: Oracles "Partition" keyword
by bradbueche
::
Rate this Message:
It turns out it was just me working too many hours too many days in a
row (I guess). Its working now. It was suprising as I would think (I'm brand new to cf) that cf would just pass the entire string to the db (an not analyze the submission). [Which is why Mr. Comer's response baffles me.....cf just submits the query....at that point, its up to the db] This started because the cf wizard in flex 3 just went out to lunch when I used the word partition. I'll re-tackle that tomorrow. Sometimes I get obsessive and just cant stop when I should go get some sleep! Sorry for wasting y'alls time, but thanks for the response. brad -----Original Message----- From: James Holmes [mailto:james.holmes@...] Sent: Thursday, January 15, 2009 7:25 PM To: sql Subject: Re: Oracles "Partition" keyword Is reporter_db a table or schema name? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/16 Brad Bueche <brad@...>: > I need to query a very large oracle database of network event traffic. > I cant really do any sort of efficient query unless I can specifiy > partition: > > SELECT * > FROM reporter_db PARTITION (P200901) > > CF doesnt seem to recognize the "PARTITION (P200901)" > > Is there some special syntax I have to use to get it to recognize > this? > > thanks > brad > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3175 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6 |
| Free embeddable forum powered by Nabble | Forum Help |
