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" > <[EMAIL PROTECTED]> 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/
