Halo Subekti-san,
thanks a lot ya ... point pertama sangat menarik, terlebih space hardisk di server dah lumayan sumpek... :) Ada yg bisa nambahin ? gimana dengan index ? 2010/2/19 Subekti Pranoto <[email protected]> > > > pak firman, > > menurut saya, langkah-langkah nya sbg berikut: > 1. tambah hard disk dulu pak.. karena apa? karena datanya maksimal pasti 2x > > 80 juta record. > 2. rename table lama > 3. create table baru yang ada partisinya (asumsi saya bulan, tahun) > 4. select dari table lama, range bulan x tahun y, > kemudian > insert ke table baru. > 5. archive data di table lama yg sudah dipindah, ke table temporary > 6. loop no 4-5, sampai last data. > 7. examine data yg tidak masuk kriteria, loop no 4-5, sampai last data > 8. delete table temporary > 9. delete table lama. > > > ----- Original Message ----- > From: "Moch Firman N" <[email protected] <mochfirman%40gmail.com>> > To: <[email protected] <indo-oracle%40yahoogroups.com>> > Sent: Friday, February 19, 2010 3:29 PM > Subject: Re: [indo-oracle] Advice tuk partisi table > > > Halo Murdi-san, > > > > > > Thanks a lot tuk advice nya... > > > > Gimana dengan sizing ? timing ketika import ke table partitioned > > mengingak > > datanya sudah 80jt records ? > > > > Ada yg bisa nambahkan.... > > > > 2010/2/19 murdi santoso <[email protected] <sandi_ui%40yahoo.com>> > > > >> > >> > >> partisi table dibuat pada create tabledan bisa ditambah partisinya > >> nantinya, table yg sudah terbuat dan belum terpartisi dan hendak di > >> partisi, > >> tidak bisa di buatkan partisi. > >> > >> jadi solusi membuat table yg sudah ada untuk di partisi yaitu rename > >> table > >> tersebut dan create table baru yg ada partisnya dan data di pindah dari > >> table yg telah di rename ke table baru yg sudah ada partisnya. > >> > >> ________________________________ > >> From: Moch Firman N <[email protected] > >> <mochfirman%40gmail.com><mochfirman% > 40gmail.com>> > >> To: indo-oracle > >> <[email protected] <indo-oracle%40yahoogroups.com> > <indo-oracle%40yahoogroups.com> > > >> > > >> Sent: Fri, February 19, 2010 2:36:54 PM > >> Subject: [indo-oracle] Advice tuk partisi table > >> > >> > >> Dear All... > >> > >> Langsung saja, > >> Saat ini sy punya table yg berisi -/+ 80 juta records. dan planningnya > >> table > >> ini akan di partisi by range. > >> Ada yg mau share pengalaman tuk mem-partisi table ? Hal apa saja yg > perlu > >> di > >> pertimbangkan > >> > >> -- > >> Yours sincerely, > >> Mochamad Firman Nurdiansyah > >> > >> [Non-text portions of this message have been removed] > >> > >> [Non-text portions of this message have been removed] > >> > >> > >> > > > > > > > > -- > > Yours sincerely, > > Mochamad Firman Nurdiansyah > > > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: > > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > > Website: http://indooracle.wordpress.com > > http://www.facebook.com/group.php?gid=51973053515 > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > -- Yours sincerely, Mochamad Firman Nurdiansyah [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! 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: [email protected] [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/
