Re: Personnal Oracle: Error

gm_at_FormalSys.CA (GENE MAILLET) wrote:

GM> I am trying to load 223,041 records into 1 table on personal oracle
GM> for win95 using the import utility.   After 100,298 rows I get
GM> the error
GM> ORA-03113:  End-of-file on communication channel.

We're getting the same error, but it's to an Oracle instance on a 12 node MPP machine. The network trace indicates that the Oracle instance for some obscure reason closes the TCP connection by sending a FIN bit.

But with Personal Oracle you're not using any network protocols. When you start P7 a hidden application called ora_orcl runs in the background. The client tools communicate with this app via the SQL*Net driver using some kind of local comms method <anyone knows what it is?>. The error you've encountered basically means that the ora_orcl has dropped the comms channel to SQL*Net for that specific client programming you're running. If we know what type of comms are used between SQL*Net and the local P7 instance, this 3113 error can be debugged. In the meantime I suggests that you use the load and skip parameters of SQL*Loader and load your data into 100,000 or 50,000 row chunks.

regards,
Billy
vslabs_at_onwe.co.za Verreynne Software Labs, Johannesburg Z.A.

• RM 1.31 3337 *