Thanx ya atas feedback nya..., klw soal googling sudah mas.... :D Oh iya, Apa ada cara yg lebih halus.. tanpa meng-drop undo yg lama.. :) cuma nge-clear ?
danke, On Jan 9, 2008 3:31 PM, Trio Syamsul Benny <[EMAIL PROTECTED]> wrote: > Udah coba googling mas? > > Dulu pernah juga ngelakuin ini, caranya kira2: > - Login as sys. > - Create undo tablespace ke dua. > SQL> create undo tablespace UNDOTBS2 datafile > "/oracle/oradata/codotdb/undotbs2.dbf" size 1000m; > - Set undo tablespace ke tablespace yang baru itu > SQL> alter system set undo_tablespace=UNDOTBS2; > - Drop old undo tablespace lam > SQL> drop tablespace UNDOTBS1 including contents; > > Klo didrop gak bisa, berarti masih dipake undotbs1, coba force switch ke > log > berikutnya. > > -benny- > > > On 1/9/08, Moch Firman N <[EMAIL PROTECTED] <mochfirman%40gmail.com>> > wrote: > > > > Dear All, > > > > Untuk meng-clear tablespace undo cara-nya gimana? Ada yg bisa ngasih > > penjelasan..!!! > > > > Terima kasih, > > > > Best regards > > Moch Firman N > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
