-
re: creating a spatial index using dbms_job
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
thanks,
harish
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|