insert problem

I tried to insert some rows into a table and I got this errors


ORA-03113: end of file on communication channel.

please advise

You lost connection to database or the instance is shutdown, reconnect and try again, it should work if the instance is up.

Thanks for your reply, the problem is not I got disconnect and reconnect and run.

The problem is my connection will be disconnect everytime I ran this insert statement. I do believe that it's a bug in ORacle

by the way, I am running 8.1.7 on windows 2000 server.

Possibly. What did your alert.log and trace file say?

What tool are you using for starting the insert ?
Is it a GUI program? SQL*Plus ?

What type of data are you trying to insert ?

That's Oracle bug. It works now after I add one parameter to work around without applying the patch

Thank you all

Hey.....will you please educate all of us here @ what parameter helped you ?

bug number 1099596 or you can add this parameter :_IGNORE_DESC_IN_INDEX = TRUE

thats should do


can someone please help me to tune this query ??? I posted it in here twice, but I guess it was removed for some reason.

here is the query and it Oracle Spatial:

SELECT b.grid_key,
b.grid_lvl1_key, b.grid_lvl1_code, b.grid_lvl1_name,
b.grid_lvl2_key, b.grid_lvl2_code, b.grid_lvl2_name, b.grid_fips_st_code
FROM grid_master a, grid_master b, USER_SDO_GEOM_METADATA M
WHERE m.table_name = 'GRID_MASTER' AND m.column_name = 'SOB_GEOMETRY'
AND SDO_RELATE(A.sob_geometry, B.sob_geometry,'mask=inside querytype=WINDOWDS') = 'TRUE' AND a.grid_key=6909 and b.grid_lvl = a.grid_lvl -1;

Thanks

FYI: It was not removed, instead it had been moved to the development forum.


Sam