Re: Drop a Global Temporary Table using Classic ASP

On Jun 12, 9:08 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
>
> > Daniel,
>
> > I've tried to respond several times. I am hoping that one of these
> > transmissions will go through.
>
> > We are running the sql via a web application and once the data has
> > been rendered, we wanted to administer clean up.
>
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

Daniel,

Yes, I do know what a GTT is and what they are used for. Thanks for taking time to respond. Received on Wed Jun 13 2007 - 09:49:52 CDT