Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-03113 error

Re: ORA-03113 error

From: Feng Xiong <fengx_at_wolfram.com>
Date: Mon, 15 Mar 1999 16:20:38 -0600
Message-ID: <36ED87B6.6DD14945@wolfram.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US