INdex Creation / SQL/PL Problem?

[SteinLaus]

HI out there,

i have a Problem with the interMedia Context Server.
After Importing a large Dump 250MB, im about to create an index.
CREATE INDEX AV_STR_VAL ON ATRIBUTEVALUE(STRINGVALUE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('Memory 50M');
also tried it with 500M ... but the same Problem:

After a short while the PL Script is hanging and the CPU Load is 100% for the Script. The CTX Log says 1600 documents indexed. Thats it. Nothing else ... No error Message at all.

So is there a way to find out whats going on there? Maybe a Log for what he is really doing.

Thaks alot
P.S: Please if possible post scripts as im no DBA till now :)

[LND]

isn't it better to run a script to create index based on index type?
At least this is the only valid option we know for SDO indextype based indexes.