Re: ORA-03113 error

Did you have any network or server problems when you ran it? Make sure your network is properly configured and also check your trace files for possible errors.

Feng

Arthur Merar wrote:

> Hello,
>
> I run the following insert statement and get an error. Oracle runs
> the insert for about 30 seconds then gives me the following:
>
> ORA-03113 End of file on communications channel.
>
> What does this mean and why is it happeneing? This is a simple insert
> statement......I am taking fields from one table and inserting them
> into another table........
>
> All parens are balanced and stuff.....so I do not get it. Any help is
> appreciated.
>
> Thanks,
>
> Arthur
> amerar_at_unsu.com
>
> insert into cash_man.ej1_art (TRANDATETIME,
> SEQNUM,
> USERID,
> WSID,
> OFFICENAME,
> EFFCTVDATE,
> CATEGORY,
> RECEIVEDDATE,
> TRANNAME,
> TRANTYPE,
> VOIDSTAT,
> CORRSTAT,
> XMITSTAT,
> SUSPENDED,
> SUPERVID,
> BATCHNUM,
> TRANNUM,
> CORRDTRANNUM,
> CORRNTRANNUM,
> CONTDTRANNUM,
> CONTNTRANNUM,
> TRANAMT,
> ACCTNUM,
> TRANCODE,
> TABNUM,
> HOSTRSPMSG,
> OTHERDATA,
> MISC1,
> MISC2,
> MISC3,
> MISC4,
> MISC5,
> MISC6,
> MISC7,
> MISC8,
> MISC9,
> MISC10,
> MISC11,
> MISC12,
> ACCOUNTKEY1,
> ACCOUNTKEY2,
> ACCOUNTKEY3,
> ACCOUNTKEY4,
> ACCOUNTKEY5,
> CITYID,
> TRANAMT_N,
> DATE_TIME_BATCH_CLOSED,
> TRAN_AMT_CASH1,
> TRAN_AMT_CHECK1,
> TRAN_AMT_CREDIT1,
> TRAN_AMT_CASH2,
> TRAN_AMT_CHECK2,
> TRAN_AMT_CREDIT2,
> MISC13,
> MISC14,
> MISC15,
> MISC16,
> MISC17,
> MISC18,
> MISC19,
> MISC20,
> MISC21,
> MISC22,
> MISC23,
> TRAN_AMT_CASH3,
> TRAN_AMT_CHECK3,
> TRAN_AMT_CREDIT3,
> TRAN_AMT_CREDIT1EL,
> TRAN_AMT_CREDIT2EL,
> TRAN_AMT_CREDIT3EL,
> TRAN_AMT_CREDIT1LC,
> TRAN_AMT_CREDIT2LC,
> TRAN_AMT_CREDIT3LC,
> TRAN_AMT_CREDIT1AC,
> TRAN_AMT_CREDIT2AC,
> TRAN_AMT_CREDIT3AC,
> TRAN_AMT_CREDIT1FS,
> TRAN_AMT_CREDIT2FS,
> TRAN_AMT_CREDIT3FS,
> TRAN_AMT_CREDIT1OT,
> TRAN_AMT_CREDIT2OT,
> TRAN_AMT_CREDIT3OT)
> select (TRANDATETIME,
> SEQNUM,
> USERID,
> WSID,
> OFFICENAME,
> EFFCTVDATE,
> CATEGORY,
> RECEIVEDDATE,
> TRANNAME,
> TRANTYPE,
> VOIDSTAT,
> CORRSTAT,
> XMITSTAT,
> SUSPENDED,
> SUPERVID,
> BATCHNUM,
> TRANNUM,
> CORRDTRANNUM,
> CORRNTRANNUM,
> CONTDTRANNUM,
> CONTNTRANNUM,
> TRANAMT,
> ACCTNUM,
> TRANCODE,
> TABNUM,
> HOSTRSPMSG,
> OTHERDATA,
> MISC1,
> MISC2,
> MISC3,
> MISC4,
> MISC5,
> MISC6,
> MISC7,
> MISC8,
> MISC9,
> MISC10,
> MISC11,
> MISC12,
> ACCOUNTKEY1,
> ACCOUNTKEY2,
> ACCOUNTKEY3,
> ACCOUNTKEY4,
> ACCOUNTKEY5,
> CITYID,
> TRANAMT_N,
> DATE_TIME_BATCH_CLOSED,
> TRAN_AMT_CASH1,
> TRAN_AMT_CHECK1,
> TRAN_AMT_CREDIT1,
> TRAN_AMT_CASH2,
> TRAN_AMT_CHECK2,
> TRAN_AMT_CREDIT2,
> MISC13,
> MISC14,
> MISC15,
> MISC16,
> MISC17,
> MISC18,
> MISC19,
> MISC20,
> MISC21,
> MISC22,
> MISC23,
> TRAN_AMT_CASH3,
> TRAN_AMT_CHECK3,
> TRAN_AMT_CREDIT3,
> TRAN_AMT_CREDIT1EL,
> TRAN_AMT_CREDIT2EL,
> TRAN_AMT_CREDIT3EL,
> TRAN_AMT_CREDIT1LC,
> TRAN_AMT_CREDIT2LC,
> TRAN_AMT_CREDIT3LC,
> TRAN_AMT_CREDIT1AC,
> TRAN_AMT_CREDIT2AC,
> TRAN_AMT_CREDIT3AC,
> TRAN_AMT_CREDIT1FS,
> TRAN_AMT_CREDIT2FS,
> TRAN_AMT_CREDIT3FS,
> TRAN_AMT_CREDIT1OT,
> TRAN_AMT_CREDIT2OT,
> TRAN_AMT_CREDIT3OT
> from cash_man.ej1);
Received on Mon Mar 15 1999 - 16:20:38 CST