[Dbix-class] Regarding Oracle's 1000 element limit in IN clause

Darren Duncan darren at darrenduncan.net
Sat Oct 22 20:40:29 GMT 2011

Jorge Gonzalez wrote:
> One approach could be to load some temporary table with the filter data 
> and then join BIGTABLE with the temp table, but as I said, my Oracle 
> user is very limited and can't create temporary tables, much less load 
> them with data.

The best solution is to talk to the DBAs and get privileges to create/populate 
etc temporary tables (and not permanent tables).  In fact, I would argue that 
anyone with SELECT privileges should have temporary table privileges too, 
because temporary tables are just working memory for you and don't affect anyone 
else, no more than say using subqueries or other SELECT that involve collecting 
a mass of temporary data.  There's no reason they shouldn't be able to grant you 
this. -- Darren Duncan

More information about the DBIx-Class mailing list