Re: Alternative to temporary tables

According to metalink, bug 2874489 was fixed in 10.1.0.1. I am currently running 9.2.0.5. I may upgrade to 9.2.0.8 sometime in the next few months and will see if it works then. Thank you for making the table() suggestion. I'd forgotten that sql and have never used it but think it will solve my problem.

Thanks again and thanks to everyone for the suggestions, Sue

Jonathan Lewis wrote:

> That bug was fixed in 9.2.0.
>
> But if you don't want to upgrade to 9.2.0.6 you
> could consider creating an object scalar and
> table type matching the GTT structure. Then
> create a pipelined function to return the data
> you want.
> select * from table(pipelined_function)
> then behaves as a table with no storage
> behind it.
>
> Obviously there are other overheads in latching
> and CPU - but if your critical bottleneck is redo
> then this bypasses the issue.
>
> --
> Regards
>
> Jonathan Lewis
> http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Received on Fri Oct 06 2006 - 10:04:25 CDT