Re: Temp tables?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 21 Oct 1999 00:26:48 +0100
Message-ID: <940462102.22718.3.nnrp-10.9e984b29@news.demon.co.uk>

SQL Reference manual

create global temporary table XXXXX

Can't specify physical storage characteristics, space will be temporarily allocated in the tablespace which is your temporary_tablespace at the moment of demand.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Shmooth wrote in message <380E4C75.BA500AB0_at_yahoo.com>...
>I looked at the 'Getting to Know Oracle8i' book and the 'Temporary
>Tables(2-42)' referred me to the 'Oracle Concepts' documentation, but all
>I could find there were references to temp 'tablespaces' and 'segments'.
>
>Where can I find docs on temp tables? Like SQL to create? etc.?
>
Received on Wed Oct 20 1999 - 18:26:48 CDT