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/
