Rollback segment dipakai untuk menyimpan data sebelum transaksi. Sehingga selama transaksi itu belum di commit, session lain masih dapat melihat data yang original. Hal ini untuk menjaga consistency. Data tersebut juga dipakai untuk me rollback transaksi jika user mengeluarkan perintah ROLLBACK.
Kalau Anda pakai Oracle 9i and later, pakai AUTOMATIC UNDO MANAGEMENT saja. On 9/27/06, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > 1. Data Lama yg saya maksud adalah: > Contoh: > SQL> connect scott/tiger > SQL> SELECT empno, ename, sal FROM emp WHERE empno = 7902; > EMPNO ENAME SAL > ----- ----- ---- > 7902 FORD 3000 > > SQL> UPDATE emp SET sal = 5000 WHERE empno = 7902; > > Data Lamanya adalah : 3000 > Data baru : 5000 > > 2. Q: bisa sih diakalin pake insert into ... select * from .. / > sqlloader > A: bisa > - Gunakan hint PARALLEL pada SQL nya, biar lebih cepet. > - Gunakan direct method/option ketika menjalankan SQL*Loader > > CMIIW, > > Bowo > > --- In [email protected] <indo-oracle%40yahoogroups.com>, "Ronal > Yulyanto" > <[EMAIL PROTECTED]> wrote: > > > > Iya mas terima kasih atas masukannya, sudah bisa... thanks..., iya > undo > > managementnya manual..., maksudnya 'data lama' itu apa yaa...?? > sama seperti > > "partition' atau apa..?? > > > > btw klo mau copy isi table yang rownya besar banget mencapai 1 jt > row, bgmn > > ya..???, bisa sih diakalin pake insert into ... select * from .. / > sql > > loader, tp saya merasa ada ga siih cara yang lebih praktis dan > efesien > > selain cara diatas, thank's > > > > > > On 9/26/06, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > > > > > Rollback segment dipakai untuk "undo data" or "data lama". > > > > > > Coba anda buat sebuah rollback segment baru di sebuah tablespace > yg > > > bukan SYSTEM. Jangan lupa di onlinekan. > > > > > > Dalam kasus yg anda hadapi, anda bisa ONLINEkan UNDO1, UNDO2 & > UNDO3. > > > SQL> ALTER ROLLBACK SEGMENT undo1 ONLINE; > > > > > > ? Anda pakai UNDO_MANAGEMENT=MANUAL ya??? > > > > > > Bowo > > > > > > --- In [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, "Ronal > > > Yulyanto" > > > <ronal.yulyanto@> wrote: > > > > > > > > Dear Rekan2 milist, > > > > > > > > saya mau tanya ketika saya membuat table dengan nama table > space > > > data kok , > > > > ada error > > > > > > > > ORA-01552: cannot use system rollback segment, kenapa ya ???, > > > > > > > > > > > > > > > > create table test > > > > > > > > (no varachar2(2), > > > > > > > > nama varchar2(100) > > > > > > > > tablespace data)) > > > > > > > > > > > > > > > > tetapi klo tablespacenya saya ganti system, table ter-create > > > > > > > > > > > > > > > > sebagai ref hasil select dari > > > > > > > > > > > > > > > > SELECT SEGMENT_NAME, TABLESPACE_NAME, FILE_ID,STATUS from > > > dba_rollback_segs; > > > > > > > > hasilnya : > > > > > > > > SEGMENT_NAME TABLESPACE_NAME FILE_ID STATUS > > > > SYSTEM SYSTEM 1 ONLINE > > > > SYSROL SYSTEM 1 OFFLINE > > > > UNDO1 UNDOS 5 OFFLINE > > > > UNDO2 UNDOS 5 OFFLINE > > > > UNDO3 UNDOS 5 OFFLINE > > > > > > > > oya sebenernya fungsi rollback segment itu apa, dan rollback > > > segment itu apa > > > > sih??? > > > > > > > > Thanks > > > > > > > > Ronal Yulyanto > > > > > > > > > > > > [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] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
