Re: [Q] way to shrink temporary tablespace ??
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: dba1 mcc <mccdba1@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 15:03:06 +0000
thats because it doesnt have any data in it.
Your original one does
On 1/19/06, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
>
> I don't think 2Gb is problem. I create a test
> database and extend it to 3GB then shrink it back ro
> 200m. It work.
>
>
> SQL> alter database tempfile
> '/oradata/hr/temp01hr.dbf' resize 3000m;
>
> Database altered.
>
>
> SQL> alter database tempfile
> '/oradata/hr/temp01hr.dbf' resize 200m;
>
> Database altered.
>
>
Other related posts:
