sueschoch_at_gmail.com wrote:
> The situation:
> I currently have stored procedures that use global temp tables to hold
> differing type of query criteria that is passed in to the procedure.
> This enables me to easily do a join of these temp tables with various
> permanent tables to find data a user is interested in. However, I am
> running oracle 9.2 and am running into the unresolved bug in which a
> huge amount of redo data is generated when inserting into temp tables.
> This has caused havoc in our database with lots of other applications
> failing due to no rollback space.
>
> I know I could parse out the criteria and create some complicated where
> clauses to include the criteria directly but I think there must be an
> easier way. Can anyone suggest a replacement for temporary tables?
> I've not used many of the pl/sql collections yet.
>
> I am not willing to upgrade to 10 just to solve this problem so any
> advice will be greatly appreciated.
Which type of GTT?
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Thu Oct 05 2006 - 11:31:17 CDT
