hi! Guys ,

I am running Oracle 9i on windows 2000 professional.

I am creating a spatial index on a table column.

When i try to create it from sqlplus command prompt ..

it errors out END OF FILE ON COMMUNICATION CHANNEL ..

It was suggested to be run as a job using DBMS_JOB.

I created a proc in which I use dbms_sql for creating the spatial
index.

I submit the proc as a job using DBMS_JOB.SUBMIT

When I try to run the job using DBMS_JOB.RUN(32); where 32 is the
job number it is bombing out.

*******************************************
submitted as job number 32

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00
SQL> execute dbms_job.run(32);
-29855ORA-29855: error occurred in the execution of ODCIINDEXCREATE
routine
ORA-13249: internal error in S

PL/SQL procedure successfully completed.
********************************************

Could any body help me resolve the issue and succesfully create the
spatial index ????

I have only oracle to work on this and not any applications like Arcse.

thanks,
harish