Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: GLOBAL TEMPORARY TABLE in Oracle 9.2.0.4
Tables are not removed. Data is. That is why this type of tables
is called "global". Rumor is that a company from Redmond, WA will
buy Oracle, rename it to SQL Server and then the temporary tables
will disappear at the end of session. Then we'll have one database
to rule them all, one database to find them, and in the SQL Server
bind them in the state of WA where.... I forgot the rest.
Morals of the story is that the temporary table from oracle is not
the same thing as the temporary table from the Microshit SQL Server.
Cursor is the same thing as the MS temporary table. To be consistent
with Jared's opinion about me, I have one more thing to add: RTFM.
If I mispronounced a word or two, it's because I'm a foreigner.
On 04/29/2004 11:37:31 AM, "Arnon, Yuval" wrote:
> Hi,
>
> I have been seeing a new GLOBAL TEMPORARY TABLE in our production
> database every day for the last few weeks. This table is owned by SYS
> and has the name as ORA_TEMP_1_DS_xxxxx where xxxxx is a number. The
> table structure is as follows
-- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 29 2004 - 11:07:47 CDT
![]() |
![]() |