lebih cepet lagi .. create table nya pake nologging ,.. setelah tablenya jadi , .. baru dibuat logging lagi.
2010/6/9 I Nyoman Sukaryawan <[email protected]> > buat index untuk FIELD; > > create table TABLE_NAME_2 as select from TABLE_NAME where FIELD > > To_date('2009','YYYY'); > > rename table TABLE_NAME menjadi TABLE_NAME_OLD; > > rename TABLE_NAME_2 menjadi TABLE_NAME; > > gak sampe berjam2 koq ;) dijaminnn ... hehehe > > > > > > > > > > create table as select > > 2010/6/9 bima boediman <[email protected]> > > >> >> iya mas, maksud saya, data tersebut tidak di lock oleh session lain, >> karena itu data lama tetapi jika Statement "select" itu mengunci data >> tersebut nah itu baru mungkin. Tetepi Select ga ngelock data kan ya? BTW >> udah 2jam sekarang :D >> >> ________________________________ >> From: yulius_wibowo <[email protected] <yulius_wibowo%40yahoo.com>> >> >> To: [email protected] <indo-oracle%40yahoogroups.com> >> Sent: Thu, June 10, 2010 8:25:26 AM >> >> Subject: [indo-oracle] Re: Normal Query LAMA? >> >> Lho,... SQL statement yg anda berikan khan DELETE ya thow ??? >> >> > > Terus ane jalanin SQL seperti ini : >> > > >> > > --Delete from TABLE_NAME >> > > --Where FIELD <= To_date('2009','YYYY') >> > > >> >> bw >> >> --- In [email protected] <indo-oracle%40yahoogroups.com>, bima >> boediman <bimaboedim...@...> wrote: >> > >> > Uhm Saya rasa sih tidak ya.... karena di lock jika ada process lain kan? >> jika Cuman "Select" tidak di lock kan ya Mas Yulius? >> > >> > >> > >> > >> > ________________________________ >> > From: yulius_wibowo <yulius_wib...@...> >> > To: [email protected] <indo-oracle%40yahoogroups.com> >> > Sent: Thu, June 10, 2010 8:06:41 AM >> > Subject: [indo-oracle] Re: Normal Query LAMA? >> > >> > >> > Mungkin juga karena ada record(s) yg sedang dilock oleh session lain ? >> > >> > bw >> > >> > --- In [email protected] <indo-oracle%40yahoogroups.com>, >> Hardi Tandiono <h4rd1_tt@> wrote: >> > > >> > > untuk query delete akan makan waktu lebih lama. ada baiknya querynya >> di pecah dan dicommit setelah selesai. >> > > contoh >> > > >> > > --Delete from TABLE_NAME >> > > --Where FIELD <= To_date('20090131','YYYYMMDD') and FIELD >= >> To_date('20090131','YYYYMMDD'); >> > > commit; >> > > --Delete from TABLE_NAME >> > > --Where FIELD <= To_date('20090201','YYYYMMDD') and FIELD >= >> > > To_date('20090228','YYYYMMDD'); >> > > commit; >> > > >> > > dan seterusnya. >> > > >> > > >> > > >> > > >> > > >> > > >> > > ________________________________ >> > > From: bima boediman <bimaboediman2@> >> > > To: [email protected] <indo-oracle%40yahoogroups.com> >> > > Sent: Thu, June 10, 2010 8:32:57 AM >> > > Subject: [indo-oracle] Normal Query LAMA? >> > > >> > > >> > > Para sesepuh.... >> > > >> > > Ane ada tabel isinya kurang lebih 700rb Records.... >> > > >> > > Terus ane jalanin SQL seperti ini : >> > > >> > > --Delete from TABLE_NAME >> > > --Where FIELD <= To_date('2009','YYYY') >> > > >> > > tapi udah 1jam 15 menit kok belum kelar ya?? apakah Normal atau ada >> yang ga beres? Mohon INPO please.... >> > > >> > > [Non-text portions of this message have been removed] >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > [Non-text portions of this message have been removed] >> > > >> > >> > >> > >> > >> > >> > >> > >> > [Non-text portions of this message have been removed] >> > >> >> [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://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/
