Re: [Q] way to shrink temporary tablespace ??
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 <email@example.com> wrote:
alter database tempfile
ERROR at line 1:
ORA-03297: file contains used data beyond requested