Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop a Global Temporary Table using Classic ASP
juan wrote:
> On Jun 11, 5:56 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> juan wrote: >>> Good Afternoon, >>> I am hoping someone can help me out. I want to drop a global >>> temporary >>> table in classic asp after my recordset has completed printing out >>> it's rows. >> By doing so you are defeating the entire point have having a global >> temporary table. Do you understand what they are? In Oracle? >> >> The docs are at:http://tahiti.oracle.com >> >> If you need one ... you shouldn't be dropping it. >> -- >> Daniel A. Morgan >> University of Washington >> damor..._at_x.washington.edu (replace x with u to respond) >> Puget Sound Oracle Users Groupwww.psoug.org
This may make sense in SQL Server or other Ingres based architectures but it is bad practice in Oracle. You should not be building and dropping objects in a session: Essentially ever.
I am really concerned that you don't understand what a GTT is. Have you read the docs? Do you understand where they are built and how they work? Do you understand that what you are trying to do is beat the system to death while depriving the optimizer of the information it need to do a good job?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jun 12 2007 - 21:08:31 CDT