coba aja pindahin tabel tersebut ke tablespace yang lain ( move tablespace) , trus kalo semua tabel di tablespace yang lama itu dah dipindahin tinggal di resize deh tabelspacenya, kalo udah balikin lagi tabel2nya ke tablespace yang udah di resize dan delete operation nggak membuang block2 yang udah di used.
lospubro <[EMAIL PROTECTED]> wrote: Rekan-rekan, Saya men-delete record di table dengan tujuan ingin meresize tablespace-nya supaya kecil, namun meskipun freespace di datafile itu besar tapi waktu saya resize muncul error : File contain used data beyond requested RESIZE value. Saya baca di documentation, ini karena blok-bloknya masih terpakai dan harus dipindahkan agar bisa diresize. Apakah ada saran dari rekan-rekan bagaimana memindahkan blok-blok agar datafile-nya bisa di resize? Los -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com --------------------------------- YAHOO! GROUPS LINKS Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
