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], "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>, "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] > -- -----------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/
