Re: Where is a temp tables DDL stored?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 14 Sep 2005 07:32:11 -0700
Message-ID: <7YCdnTV98IGAqbXeRVn-sg@comcast.com>

"g3000" <carlton_gregory_at_yahoo.com> wrote in message news:1126707526.762209.164070_at_f14g2000cwb.googlegroups.com...
> My question is how does Oracle determine where the DDL for the temp
> table is stored?
>
> And no, I am not porting MSSQL code.
>
> There is an accurate answer to this question and thats what I am
> seeking.
>

Are you using global temporary tables or creating them on the fly? (GTT are the way to go not the other)
Jim Received on Wed Sep 14 2005 - 09:32:11 CDT