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

Home -> Community -> Mailing Lists -> Oracle-L -> Temporary space....

Temporary space....

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Tue, 26 Apr 2005 10:35:36 +0530
Message-ID: <a144e5210504252205496a0a21@mail.gmail.com>


I have few confusions:

  1. In my temporary tablespace, space not getting released even if the user has finished with the work. Ideally once the user using temporary tablespace, finished the job, space in the temporary tablespace used by the user should be released. But its not. Any idea why?
  2. whats the diff between the two commands: create tablespace temp datafile .......... temporary; create tablespace temp tempfile .......... temporary.

Thanx in advance

--=20

Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)

       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 26 2005 - 01:09:51 CDT

Original text of this message

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