way to shrink temporary tablespace ?? 2006-01-19 - By David Sharples
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@(protected)> wrote:
>
> alter database tempfile
> '/u/oradata/DECDB/temp01DECDB.dbf' resize
> 2000m
> *
> ERROR at line 1:
> ORA-03297 (See ORA-03297.ora-code.com): file contains used data beyond requested
> RESIZE value
>
<div>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.<
/div>
<div> </div>
<div>Create a new temporary ts then drop old one</div>
<div> </div>
<div>As for cold backup, no you dont need to back it up<br><br> </div>
<div><span class="gmail_quote">On 1/19/06, <b class="gmail_sendername">dba1 mcc
</b> <<a href="mailto:mccdba1@(protected)">mccdba1@(protected)</a>> wrote:<
/span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">alter database tempfile<br>'/u/oradata/DECDB
/temp01DECDB.dbf' resize<br>2000m<br>*<br>ERROR at line 1:<br>
ORA-03297 (See ORA-03297.ora-code.com): file contains used data beyond requested<br>RESIZE value<br><
/blockquote></div>
|
|
