ORA-03113 End of file on communication Channel error when accessing Spatial Indexes
Posted on 2004-08-02
Hello. I have recently installed a 188.8.131.52 Oracle Spatial database, and am getting the <ORA-03113: End of file on communication Channel> error when accessing Spatial Indexes (query/drop/create/etc). It was going fine to start with, but four invalid SYS.ODCIINDEXxxxx types were concerning me - even though they were apparently not directly causing any problems. On Metalink (TAR 3903528.996), Oracle adviced me to run the following statements:
ALTER TYPE SYS.ODCICOLINFO RESET;
ALTER TYPE SYS.ODCIARGDESC RESET;
ALTER TYPE SYS.ODCICOST RESET;
ALTER TYPE SYS.ODCIINDEXINFO RESET;
Did that, and it validated the objects. But ever since then, I get the ORA-03113 for anything that requires a spatial index. Does anyone know what the above 4 statements actually did, or how I can retract my steps? Also, has anyone ever encountered this problem before. Also, I haven't really been able to work out the link between Data Cartridge and the Spatial Indexes. Lots of questions I know, but am getting desperate!!! Any light on the subject will be appreciated! Thanks.