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
