[Q] way to shrink temporary tablespace ??
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 19 Jan 2006 05:47:14 -0800 (PST)
We have OARCLE 9ir2 on Redhat LINUX server. database
temporary tablespace grow up to 10GB. I tried to
sxhrink it and have error message:
alter database tempfile
'/u/oradata/DECDB/temp01DECDB.dbf' resize
2000m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested
RESIZE value
Anyone know how to fix it?
Another question is for ORACLE Cold backup do I need
backup temporary tablespace?
Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » [Q] way to shrink temporary tablespace ??
