insert problem

[ashley75]

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


ORA-03113: end of file on communication channel.

please advise

[Knarayan]

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

[ashley75]

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.

[marist89]

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

[svk]

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 ?

[ashley75]

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

Thank you all

[svk]

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

[ashley75]

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

[sambavan]

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


Sam