Ron,
- Data files in this case would be visible in dba_temp_files
- The object will exist after the session has ended but it will release any space if the session created rows in that object. In other words as you create more rows, it will allocate extents, as soon as your session ends it will release those temp extents, it will still have some space allocated to it since the definition of the table will remain in the schema.
You can verify space allocation/deallocation using v$sort_usage dynamic view.
Regards,
Viral
>From: "Ron Rogers"
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: More question about TEMP
>Date: Fri, 08 Nov 2002 07:33:34 -0800
>
>List,
>Sorry for the confusion.
> As the DBA I "grant create session to rrogers" and "grant create
>table to rrogers"
>As rrogers I
>"create temporary tablespace fubar
>tempfile '/data4/ror.dbf 'size 10M
>extent management local uniform size 128k;"
>
>The tablespace gets created and is visable by the DBA with
>"Select * from dba_tablespaces where tablespace_name 'FUBAR';"
>The datafile is NOT visable in the dba_data_files view.
>
>As rrogers I create a table
>"Create global temporary table testror(
>col1 char(1000));"
> The table is visable to the DBA as
>select * from dba_tables where owner ='RROGERS';
>and desc rrogers.testror.
>
>As rrogers I exit the system and the table is still visable to the DBA.
>The manual says that the "temporary tablespace"fubar is an allocation
>of space that can contain schema objects for the duration of the
>session" If this is so then why is the table still there.???
>I think that the manual should read that the object created can contain
>data only for the duration of the session.... Or something to the same
>effect as the objects still exist after the session has ended.
>Am I correct in my tests?
>Ron
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ron Rogers
> INET: RROGERS@galottery.org
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Add photos to your e-mail with
MSN 8. Get 2 months FREE*.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viral Desai
INET: viral303@hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Nov 08 2002 - 10:39:00 CST