Re: Shrink Temp Tablespace

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