thanx ronald, tapi saya sudah menemukan cara nya , kalau menurut cara ronald secara detail model script nya gimana ?
berikut step2 menurut cara saya, sudah dicoba dan barhasil, berlaku buat tablespace lain, bukan tablespace system saja: step2: 1. set verify off column file_name format a50 word_wrapped column smallest format 999,990 heading "Smallest|Size|Poss." column currsize format 999,990 heading "Current|Size" column savings format 999,990 heading "Poss.|Savings" break on report compute sum of savings on report column value new_val blksize 2. select file_name, ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest, ceil( blocks*&&blksize/1024/1024) currsize, ceil( blocks*&&blksize/1024/1024) - ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) savings from dba_data_files a, ( select file_id, max(block_id+blocks-1) hwm from dba_extents group by file_id ) b where a.file_id = b.file_id(+) / 3. column cmd format a75 word_wrapped 4. select 'alter database datafile '''||file_name||''' resize ' || ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd from dba_data_files a, ( select file_id, max(block_id+blocks-1) hwm from dba_extents group by file_id ) b where a.file_id = b.file_id(+) and ceil( blocks*&&blksize/1024/1024) - ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0 / thanxs, Dody --- On Wed, 7/2/08, ronald speirs <[EMAIL PROTECTED]> wrote: From: ronald speirs <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] resize tablepsace system To: [email protected] Date: Wednesday, July 2, 2008, 12:26 AM dengan asumsi menggunakan 10g, dan ASSM (automatic segment space management) digunakan pada saat pembuatan tablespace, maka lowering high watermark bisa dilakukan dengan 2 step: 1) enabling ROWID movement 2) segment shrink semoga membantu On Mon, Jun 30, 2008 at 11:17 AM, dody osmon <dodytanjung79@ yahoo.com> wrote: > Hai, > > salam kenal semua, bagaimana cara untuk resize tablepspace system yg besar > nya sudah 3 giga, padahal yang ke pakai cuma 500 M, sudah di coba pake > alter tablespace resize, tetapi tidak bisa . > > Thx [Non-text portions of this message have been removed]
