Betul, oracle kami ver 8 dan kami melakukan transaksi kepada table snap$_xxx.
Kemarin itu masalahnya timbul karena tabel log_xxxnya tidak ada. Akhirnya kami mengcreate ulang table tersebut. Terima kasih Rgds, Herry ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of bukhari yahya Sent: Tuesday, December 04, 2007 2:56 PM To: [email protected] Subject: Re: [indo-oracle] ora-00604, ora-00942 pak kalau saya tidak salah bapak pasti menggunakan oracle 8? untuk query dml memang tidak dapat melalui table snap$ tapi melalui nama snapshotnya: contoh: jika nama snapshot nya adalah --> table1, maka akan muncul snap$_table1 dan tabel log (us_log klo saya tidak salah) , dan anda semestinya dapat melakukan query *insert into table1 *walaupun table1 tidak ada pada daftar schema object tabel. Untuk oracle 9i, akan berbeda lagi, karena sudah memakai materialized view, tetapi secara prinsip hampir sama. Salam Yahya On 12/4/07, Herry Yusirwan <[EMAIL PROTECTED] <mailto:herry.yusirwan%40indonesiapower.co.id> > wrote: > > Terima kasih atas bantuan teman2 untuk mensolve masalah yang saya > miliki. > > Masalahnya adalah setiap table snap$ yang terdapat pada database kami > memang berasal dari replikasi dan updateable. > > Setiap table snap$ tersebut mempunya table log dengan nama yang sama > (entah ini dibuatkan sebagai pencatatan replikasi sepertinya). > > Table log tersebut hilang yang menyebabkan proses insert, update, delete > tidak dapat dilakukan pada table snap$ karena sepertinya pencatatan > transaksi dilakukan pada table log tersebut (CMIIW). > > Setelah kami create table log tersebut, proses transaksi lancer kembali. > > Teman2 ada yang bisa menjelaskan hal ini. > > Terima kasih > > Rgds, > > Herry > > DISCLAIMER: > This Message is confidential; it contents does not constitute a commitment > by PT. INDONESIA POWER, except where provided for in a written agreement > between you and PT. INDONESIA POWER. Any unauthorized disclosure, use or > dissemination of the content, either whole or partial, is strictly > prohibited. If you are not the intended recipient of the message or you have > received this electronic transmission in error, please notify or contact the > sender immediately. > > PT.INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates in > power generating business. Through its 130 power plants, with a total > capacity of 8,872 MW, PT.INDONESIA POWER has contributed significantly to > the Java Bali interconnection system electricity supply. PT.INDONESIAPOWER operates through its eight generating Business Unit (GBU) : Suralaya, > Priok, Saguling, Kamojang, Mrica, Semarang, Perak Grati, Bali and one > maintenance Services business unit (MSBU). > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] DISCLAIMER: This Message is confidential; it contents does not constitute a commitment by PT. INDONESIA POWER, except where provided for in a written agreement between you and PT. INDONESIA POWER. Any unauthorized disclosure, use or dissemination of the content, either whole or partial, is strictly prohibited. If you are not the intended recipient of the message or you have received this electronic transmission in error, please notify or contact the sender immediately. PT.INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates in power generating business. Through its 130 power plants, with a total capacity of 8,872 MW, PT.INDONESIA POWER has contributed significantly to the Java Bali interconnection system electricity supply. PT.INDONESIA POWER operates through its eight generating Business Unit (GBU) : Suralaya, Priok, Saguling, Kamojang, Mrica, Semarang, Perak Grati, Bali and one maintenance Services business unit (MSBU). [Non-text portions of this message have been removed]
