Re: ORA-03113 error

[Quoted] Looks like you are working through the sqlnet. Try to get a trace file, set

TRACE_LEVEL_CLIENT=16 in sqlnet.ora.

[Quoted] Most of 3113 error messages actually related to huge amount of server bugs. Try to contact your support representative (if you have a support contract).

[Quoted] In article <36ecf9b0.25371213_at_news.chaven.com>,   amerar_at_unsu.com (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);
>
>

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 16 1999 - 00:00:00 CET