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