Hi, utk tablespace system yg sdh disetting sebesar 3 GB , sebaiknya jangan dikecilkan. Apabila memang kurang dan file system nya sdh mencapai 3 GB, sebaiknya dibuatkan ke file lain dengan tablespace yg sama. Adapun langkahbnya sbb : Cek Space Masing-masing table space:
select sum(bytes)/(1024*1024) ,tablespace_name,file_name from dba_data_files where tablespace_name like '%SYS%' group by tablespace_name,file_name; Sedangkankan utk cek Free Space Tablespace sbb : select sum(bytes)/(1024*1024),tablespace_name from dba_free_space where tablespace_name like '%SYS%' group by tablespace_name Dan utk menambahkan size table space bisa mengunakan resize tablespace sbb : alter database datafile '/data/applmgr/proddata/fax01.dbf' resize 500m; Sedangkan utk menambahkan file utk table space sbb : alter tablespace GLD add datafile '/data/appltest/testdata/gld02.dbf' size 10m; Regard's Rudy --- On Mon, 6/30/08, dody osmon <[EMAIL PROTECTED]> wrote: From: dody osmon <[EMAIL PROTECTED]> Subject: [indo-oracle] resize tablepsace system To: [email protected] Date: Monday, June 30, 2008, 11:17 AM 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] [Non-text portions of this message have been removed]
