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