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=11502.10531.6
