Sedikit menambahkan info dari bro Bambang. Jika memakai parameter file init.ora, jangan lupa mengganti parameter undotablespace menjadi undo yang baru, kalau tidak diganti, db tidak mau startup.
tapi kalau memakai spfile, saat ALTER SYSTEM SET UNDO_TABLESPACE='UNDO2' tambahkan parameter scope=both ALTER SYSTEM SET UNDO_TABLESPACE='UNDO2' scope=both; ----- Original Message ----- From: Bambang Sutejo<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: Friday, March 20, 2009 8:57 AM Subject: Bls: [indo-oracle] Undo Tablespace Full Drop dan Ganti Undo tablespace 1. buat yg baru dulu CREATE UNDO TABLESPACE UNDO2 DATAFILE 'C:\...\UNDO2.DBF' size 100 M autoextend ON next 1m maxsize 1000M; 2. Ganti undo tablespace untuk database dengan merubah parameter UNDO_TABLESPACE ALTER SYSTEM SET UNDO_TABLESPACE='UNDO2'; 3. Baru hapus yang lama DROP TABLESPACE ... Demikian semoga membantu Salam Bambang Sutejo www.klik-oracle.web.id --- Pada Kam, 19/3/09, wahib ashari <[email protected]<mailto:wahibshr%40yahoo.com>> menulis: Dari: wahib ashari <[email protected]<mailto:wahibshr%40yahoo.com>> Topik: [indo-oracle] Undo Tablespace Full Kepada: [email protected]<mailto:indo-oracle%40yahoogroups.com> Tanggal: Kamis, 19 Maret, 2009, 10:45 AM 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/ [Non-text portions of this message have been removed] Buat sendiri desain eksklusif Messenger Pingbox Anda sekarang! Membuat tempat chat pribadi di blog Anda sekarang sangatlah mudah. http://id.messenger.yahoo.com/pingbox/ [Non-text portions of this message have been removed] ________________________________ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. [Non-text portions of this message have been removed]
