solosinya bukan drop dan recreate lagi undo tablespace, tapi seharusnya tambahkan add datafile.
salam wahib ashari wrote: > > Salam semua,.. > > Maaf sebelumnya, saya newbie dan lagi menemui kendala > saat ini saya sudah tidak bisa menambah data ke database (Ket: saya > pake tool TOAD) > saat proses insert muncul error message > > ORA-30036: unable to extend segment > by string in undo tablespace > "string" > > Setelah dicek ternyata Undo Tablespacenya sudah 99% (penuh), kemudian > rencana saya drop dan recreate lagi undo tablespace. > > tapi saat drop tablespace ada keterangan "table space is currently in use" > kalau saya Take Offline muncul "error message cannot offline the undo > tablespace" > > Mohon Pencerahannya teman2.. > Terima kasih sebelumnya > > Regards > Wahib > > Get your preferred Email name! > Now you can @ymail.com and @rocketmail.com. > http://mail.promotions.yahoo.com/newdomains/aa/ > <http://mail.promotions.yahoo.com/newdomains/aa/> > > [Non-text portions of this message have been removed] > > -- =============================== gold jewelry manufacture UBSGOLD.COM UNIVERSE OF GOLD UNTUNG BERSAMA SEJAHTERA ===============================
