Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: More question about TEMP

Re: More question about TEMP

From: Viral Desai <viral303_at_hotmail.com>
Date: Fri, 08 Nov 2002 08:39:00 -0800
Message-ID: <F001.004FEDE5.20021108083900@fatcity.com>

Ron,

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US