tapi kalau transaksi sedang padat,pernah mengalami waitlock, apakah karena waitlock tsb bisa merubah data yg ada? --- Pada Rab, 19/8/09, Mohammad Arief Pradipto <[email protected]> menulis:
Dari: Mohammad Arief Pradipto <[email protected]> Judul: Re: External Email : --> Re: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... Kepada: [email protected] Tanggal: Rabu, 19 Agustus, 2009, 9:12 PM Mungkin pak Teguh harus ngecek lagi segala yang berkaitan dengan tabel transaksi/detail transaksi tersebut, hal hal yang mentouch ke tabel tersebut seperti: a. Trigger b. Function/Prosedure c. Package d. Jobs e. Scheduled Concurrent f. Scheduled cronjob dll... regards, adipt ----- Original Message ----- From: Teguh Susanto<mailto:teguh4milis@ yahoo.com> To: indo-oracle@ yahoogroups. com<mailto:indo-oracle@ yahoogroups. com> Sent: Thursday, August 20, 2009 8:04 AM Subject: External Email : --> Re: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... mungkin sy perjelas lagi masalah nya: spesifik table : 1. table transaksi (no_bukti,tgl_ transaksi, no_faktur) 2. table detail transaksi (no_bukti,kd_ item,qty, harga,no_ faktur) contoh transaksi #1 transaksi ('0001','2009- 08-01','F001' ); detail transaksi ('0001','ITM0045' ,2,5000,' F002'); //saat dientry jelas F001,tapi beberapa hari kemudian berubah menjadi F002 detail transaksi ('0001','ITM0025' ,1,7000,' F001'); detail transaksi ('0001','ITM0030' ,1,4000,' F001'); transaksi #2 transaksi ('0002','2009- 08-01','F002' ); detail transaksi ('0002','ITM0075' ,1,10000, 'F002'); detail transaksi ('0002','ITM0010' ,1,10000, 'F002'); --- Pada Rab, 19/8/09, Ahmad Jali <ahmadm...@yahoo. com<mailto:ahmadmj72% 40yahoo.com> > menulis: Dari: Ahmad Jali <ahmadm...@yahoo. com<mailto:ahmadmj72% 40yahoo.com> > Judul: Re: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... Kepada: indo-oracle@ yahoogroups. com<mailto:indo- oracle%40yahoogr oups.com> Tanggal: Rabu, 19 Agustus, 2009, 1:54 AM coba tolong di cek kembali no faktur di transaksi 1 dan 2 kalau di selectnya di detail transaksi, pasti akan ada 2 record. ____________ _________ _________ __ From: Teguh Susanto <teguh4milis@ yahoo.com> To: indo-oracle@ yahoogroups. com Sent: Wednesday, August 19, 2009 1:45:02 PM Subject: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... kepada Senior DBA&Miliser Oracle yg sy hormati saya pakai oracle 9i,saya sering kali dpt kompain dari user karena transaksi yg mrk lakukan sering ketambahan data sendiri atau ada detail transaksi yg hilang spesifik table : 1. table transaksi (no_bukti,tgl_ transaksi, no_faktur) 2. table detail transaksi (no_bukti,kd_ item,qty, harga,no_ faktur) contoh transaksi #1 transaksi ('0001','2009- 08-01','F001' ); detail transaksi ('0001','ITM0045' ,2,5000,' F002'); transaksi #2 transaksi ('0002','2009- 08-01','F002' ); detail transaksi ('0002','ITM0075' ,1,10000, 'F002'); jadi klo saya "SELECT a.* FROM detail_transaksi where no_faktur='F002' " akan tampil 2 record.. yang jadi pertanyaan kenapa hal tersebut terjadi? bagaimana solusinya? sebelumnya saya ucapkan terimakasih. .. regrads teguh "Coba Yahoo! Mail baru yang LEBIH CEPAT. Rasakan bedanya sekarang! http://id.mail. yahoo.com& quot; [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ____________ _________ _________ _________ _________ _________ _ Coba emoticon dan skin keren baru, dan area teman yang luas. Coba Y! Messenger 9 Indonesia sekarang. http://id.messenger .yahoo.com [Non-text portions of this message have been removed] ____________ _________ _________ __ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. [Non-text portions of this message have been removed] Yahoo! Mail Kini Lebih Cepat dan Lebih Bersih. Rasakan bedanya sekarang! http://id.mail.yahoo.com [Non-text portions of this message have been removed]
