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
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
