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]> 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]
