Hello Ernest, jOOQ currently does not support Oracle's "partition extension clause" as documented here: http://docs.oracle.com/cd/E16655_01/server.121/e17209/sql_elements009.htm#i165979
But it's a good feature addition for jOOQ 3.3. I have registered feature requests for this: #2774, #2775: - https://github.com/jOOQ/jOOQ/issues/2774 (support for the partition extension clause in the runtime API) - https://github.com/jOOQ/jOOQ/issues/2775 (support for source code generation from table partitions) In the mean time, you will have to resort to a workaround involving plain SQL as documented here: http://www.jooq.org/doc/3.2/manual/sql-building/plain-sql/ In your case, as you might be frequently reusing such QueryParts, you might even want to consider implementing a CustomTable taking partition arguments: http://www.jooq.org/doc/3.2/manual/sql-building/queryparts/custom-queryparts/ Let me know if this helps. Cheers Lukas 2013/10/10 Ernest Mishkin <[email protected]> > Having scanned JOOQ docs, googled and searched this group specifically, I > can't seem to find any specific references to the subj. > > In Oracle, I can create multiple partitions for a table. Then at the > querying time, I can explicitly specify a partition for optimization and > /or constraint purposes, like this: > > SELECT * FROM TABLE TBL PARTITION(TBL_PART_1) > > It appears JOOQ does not support this syntax. Can you recommend a > work-around? > > Thanks! > > --Ernest > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
