> Adakah cara lain selain export-import, mengingat database sizenya > sudah di atas 100 GB?
anda bisa check object yg perlu di drop, sehingga yg diexport hanya object2 tertentu aja yg memang membutuhkan undo bekerja., caranya : - set di init.ora event = "10015 trace name context forever, level 10" - startup dari init.ora tsb - dari trace file generated, cari recovery tx(#.#) object # - select owner,object_name,object_type,status from dba_objects where object_id=<object #> - export object tsb sebelum di drop - drop object2 tsb - startup - import ulang object2 yg di drop .... dari metalink, quick find aja dgn keyword 107693.969 > > Terus e-mail sebelumnya, sola metalink 179952.1 itu soal apa, site di > metalink-nya di mana (tidak ketemu)? sepertinya udah gak aktif.....bisakah pak tomi attach txt filenya??? salam, J Send instant messages to your online friends http://asia.messenger.yahoo.com -- -----------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/ <*> 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/
