Dear, Kalo punya akses ke metalink, bisa coba cek note id: 153788.1 Oracle punya form lookup untuk ora-600
Kalau saya lookup di form tsb, hasilnya: ORA-600 [25012] "Relative to Absolute File Number Conversion Error" [ID 100073.1] ERROR: ORA-600 [25012] [a] [b] VERSIONS: versions 8.0 to 10.1 DESCRIPTION: We are trying to generate the absolute file number given a tablespace number and relative file number and cannot find a matching file number or the file number is zero. ARGUMENTS: Arg [a] Tablespace Number Arg [b] Relative file number FUNCTIONALITY: KERNEL FILE MANAGEMENT TABLESPACE COMPONENT IMPACT: POSSIBLE PHYSICAL CORRUPTION SUGGESTIONS: The possibility of physical corruption exists. Obtain the trace files and alert.log for this error and log an iTAR with Oracle Support Services for diagnosis. If the Arg [b] Relative file number returns 0 (zero), look for fake indexes that can cause this error. The following query list fake indexes : select a.*,b.flags from dba_objects a, sys.ind$ b where a.object_id = b.obj# and bitand(b.flags,4096)=4096; .. begitu. Mudah2an bisa membantu. CMIIW Rgds, Priyono --- In [email protected], Erika <leo...@...> wrote: > > Dear rekan2,Saya mohon bantuannya untuk memecahkan error yang dicantumkan di > bawah ini, mungkin rekan2 ada yang pernah mengalaminya? > > ORA-00600: internal error code, arguments: [25012], [31], [303], [], [], [], > [], [] > error ini muncul ketika saya ingin membuat table dengan create table as > select dari tabel lain.. > Bagaimana cara untuk mengatasinya? > Terimakasih sebelumnya untuk perhatian dan bantuannya. > Â Regards, > Erika > > > > > --- On Mon, 5/10/10, yulius_wibowo <yulius_wib...@...> wrote: > > From: yulius_wibowo <yulius_wib...@...> > Subject: [indo-oracle] Re: tidak bisa update table didalam fungsi > To: [email protected] > Date: Monday, May 10, 2010, 12:49 PM > > > > > > > > > > > > > > > > > Â > > > > > > > > > > Utk mengetahui detail errornya, coba tambahkan sqlcode & sqlerrm pada > return 'GAGAL' sbb: > > ... > > return 'GAGAL' || SQLCODE || ' - ' || SQLERRM; > > ... > > > > Bowo > > > > --- In indo-oracle@ yahoogroups. com, Teguh Susanto <teguh4milis@ ...> wrote: > > > > > > klo diluar Function bisa berhasil pak dan no urutnya bertambah, oh utk > > parameter input&output itu sebenernya ada parameter kode table itu pak tapi > > setelah sy coba masih belum terupdate > > > > > > --- Pada Kam, 6/5/10, murdi santoso <sandi_ui@ .> menulis: > > > > > > Dari: murdi santoso <sandi_ui@ .> > > > Judul: Re: [indo-oracle] tidak bisa update table didalam fungsi > > > Kepada: indo-oracle@ yahoogroups. com > > > Tanggal: Kamis, 6 Mei, 2010, 5:58 AM > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ÃÂ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > script update nya dah dicoba namual blom diluar function..? > > > > > > dan apakah berhasil..? > > > > > > > > > > > > dan parameter input funtion itu berfungsi untuk apa..? karna tdk masuk ke > > dalam script update sama skali..? > > > > > > > > > > > > UPDATE TD_NOMOR_TRANSAKSI > > > > > > SET NO_URUT=NO_URUT+ 1 > > > > > > ??? WHERE KD_TABLE = 'tm_detail_asset' ; ??? > > > > > > > > > > > > mungkin kd_table harus huruf capital upper(kd_table) . > > > > > > > > > > > > ____________ _________ _________ __ > > > > > > From: Teguh Susanto <teguh4milis@ yahoo.com> > > > > > > To: indo-oracle@ yahoogroups. com > > > > > > Sent: Thu, May 6, 2010 4:10:11 PM > > > > > > Subject: [indo-oracle] tidak bisa update table didalam fungsi > > > > > > > > > > > > kepada miliser &senior DBAsaya lagi buat function tapi belum berhasil > > banget karena update table (DDL) tidak berhasilini saya sertakan contoh > > scriptnyacreate or replaceFUNCTION GETNOMORTRANSAKSI ( fTable IN VARCHAR2 > > ) RETURN VARCHAR2 is hasil varchar2(20) ;vnomor varchar2(20) ;BEGIN > > UPDATE TD_NOMOR_TRANSAKSI SET NO_URUT=NO_URUT+ 1 WHERE KD_TABLE = > > 'tm_detail_asset' ; RETURN 'BEHASIL' ;EXCEPTION when others then > > return 'GAGAL';END GETNOMORTRANSAKSI; > > > > > > apabila fungsi tsb dirun pasti resultnya 'GAGAL', dan data di field no_urut > > tidak bertambah, mungkin dari miliser or senior DBA bisa kasih solusi > > masalah saya..a.tas perhatiannya terimakasih > > > > > > > > > > > > [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] >
