| ORA-03113: end-of-file on communication channel [message #56569] |
Wed, 09 April 2003 02:36  |
Arfat
Messages: 25
Registered: August 2002
|
Junior Member |
|
|
I m trying to insert values in a table called test in the folloeing way.
insert into test
select * from test1;
the table structures are same infact test1 is created from test table onle.
the above query gives me the error
ORA-03113: end-of-file on communication channel
And it disconnects from the server.
if i just run Select * from test1 the query runs fine.
The above query returns 2000 records.
If i restrict the insert into statement to record below 700 it works fine and insert the records
insert into test
select * from test1
Where rownum <= 700;
Can someone help me wid this problem and sugesst a solution for it.
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #56570 is a reply to message #56569] |
Wed, 09 April 2003 03:15  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
is there any corresponding error to this 03113 ???
It looks like the table is getting an overflow or something like that. If there is any other error in alert.log or trace-file it will be helpfull.
rgds
Uwe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
