I tried to insert some rows into a table and I got this errors
ORA-03113: end of file on communication channel.
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:
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;
FYI: It was not removed, instead it had been moved to the development forum.
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width