@ pak Leonard, saya mau tanya bagaimana dengan temporary tablespace pak?
2008/1/15 Leonard Sukendro <[EMAIL PROTECTED]>: > > > > > > > > to pak firman... > > setau saya (n moga2 saya gk salah :D), isi undotbs itu > jg tgantung dr parameter undo_retention.. > klo mo cepet2 di clear isinya, nilai dr parameter > undo_retention itu di kecilin aja, boss... > cmn kemungkinan efeknya klo nanti ada proses DML yg > lama.. pas proses itu bln kelar, waktu > undo_retentionnya dh tercapai, prosesnya bakal error.. > biasanya kluar error "snapshot too old.. bla2" > > tp selama masi ada proses DML, undo gk mungkin bner2 > kosong, pasti masi ada isinya.. klo mo bner2 kosong, > mesti ikutin cara pak Syamsul, boss... > > moga2 membantu, boss... > > CMIIW, > [L] > > --- Moch Firman N <[EMAIL PROTECTED]> wrote: > > > 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] > > > > > > __________________________________________________________ > Looking for last minute shopping deals? > Find them fast with Yahoo! Search. > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > -- i love being baud wanderer
