Re: long "IN" list, tempo in-memory table

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 30 Jul 1999 17:44:10 GMT
Message-ID: <37a6e3f1.13508974@newshost.us.oracle.com>

A copy of this was sent to "Kevin P. Fleming" <kfleming_at_access-laserpress.com> (if that email address didn't require changing) On Fri, 30 Jul 1999 17:03:12 GMT, you wrote:

>What kind of privileges are required to create a "global temporary table"?
>Is this a DBA-only type of process?

you need create table privs.

SQL> drop user abc;

User dropped.

SQL> grant create session, create table to abc identified by abc;

Grant succeeded.

SQL> connect abc/abc;
Connected.
SQL> create global temporary table foo ( x int );

Table created.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jul 30 1999 - 12:44:10 CDT