Re: How to get unique temp table name

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 13 Oct 2006 07:59:23 -0700
Message-ID: <1160751559.568444@bubbleator.drizzle.com>

ian wrote:
> Hi;
>
> What is the method in <SQL*Plus: Release 8.1.7.0.0> to create a unique
> temporary table name.
>
> I "create global temporary something(whatever);" and I see it lives for
> the world.

Only if you grant privileges on it to other schemas. GTT's do not violate the Oracle security model.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Oct 13 2006 - 09:59:23 CDT