Re: GLOBAL TEMPORARY TABLE in Oracle 9.2.0.4
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Apr 2004 12:07:49 -0400
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
