Re: [Q] way to shrink temporary tablespace ??
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Thu, 19 Jan 2006 13:52:22 +0000
you have data beyond the 2Gb limit of the file, there is nothing to fix and
it will stay like that as temporary tablespace segments just get reused.
Create a new temporary ts then drop old one
As for cold backup, no you dont need to back it up
On 1/19/06, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
>
> alter database tempfile
> '/u/oradata/DECDB/temp01DECDB.dbf' resize
> 2000m
> *
> ERROR at line 1:
> ORA-03297: file contains used data beyond requested
> RESIZE value
>
Other related posts:
