way to shrink temporary tablespace ?? 2006-01-19 - By David Sharples
thats because it doesnt have any data in it.
Your original one does
On 1/19/06, dba1 mcc <mccdba1@(protected)> 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.
>
>
<div>thats because it doesnt have any data in it.</div>
<div> </div>
<div>Your original one does<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">I don't think 2Gb is problem. I
create a test<br>database and extend it to 3GB then shrink it back ro<br>
200m. It work.<br><br><br>SQL> alter database tempfile<br>'
/oradata/hr/temp01hr.dbf' resize 3000m;<br><br>Database altered.<br><br><br>SQL
> alter database tempfile<br>'/oradata/hr/temp01hr.dbf' resize 200m;<br><br>
Database altered.<br><br></blockquote></div>
|
|
