Sepertinya ini bug di 10.2.0.3 yg berhubungan dengan direct path load. Workaround: pakai DIRECT=N
Patch sudah ada di metalink. Regards, tomi --- Aldry Pratama <[EMAIL PROTECTED]> wrote: > Hallo semua.. > Mohon pencerahan nih.... > Setiap hari aplikasi DW di tempat saya bekerja > menggunakan SQL Loader untuk > melakukan load data dari ribuan Text File ke > Tabel-tabel di dalam Database, > Akhir-akhir ini ketika qta periksa di alert.log nya. > muncul error / > exception seperti di bawah ini... > > ORA-07445: exception encountered: core dump > [klaevcbk()+2320] [SIGSEGV] > [unknown code] [0x000000018] [] [] > > File trace-nya diantaranya berisi: > *** ACTION NAME:(5/CDRplb2b070823195500.txt.ctl) > 2007-08-24 08:10:51.256 > *** MODULE NAME:(SQL Loader Direct Path Load) > 2007-08-24 08:10:51.256 > *** SERVICE NAME:(SYS$USERS) 2007-08-24 08:10:51.256 > *** SESSION ID:(325.3037) 2007-08-24 08:10:51.256 > > CDRplb2b070823195500.txt adalah file yang sedang di > load dengan SQL Loader. > > Mohon pencerahannya........ > > Regard, > Aldry > > > [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 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > Yahoo! Groups Links > > > > > ____________________________________________________________________________________ Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
