Re: Shrink Temp Tablespace
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: BurtonL@xxxxxxxxxxx
- Date: Thu, 5 Jan 2006 22:51:41 +0000
tempfile resize ..
not datafile
On 1/5/06, Burton, Laura <BurtonL@xxxxxxxxxxx> 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
>
Other related posts:
