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: Shrink Temp Tablespace

Re: Shrink Temp Tablespace

From: David Sharples <davidsharples_at_gmail.com>
Date: 2006-01-05 23:51:41
Message-id: be592d550601051451s933cb16q357a46896a313e66@mail.gmail.com


tempfile resize ..
not datafile

On 1/5/06, Burton, Laura wrote:
>
> to shrink the temp tablespace. On metalink I found the 'alter database
> datafile ' ' resize 500m' but this does not work; I guess due to it being
> a temp tablespace it is not listed in the dba_data_files. The error I get
> is that there is no datafile with the information I entered. Could not find
> anything which added temp into the mix
>
Received on Thu Jan 05 2006 - 23:51:41 CST

Original text of this message

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