I was trying to create text index on long type field. Simple task, did that a lot in 8i without problem.
In 9i immediately after executing CREATE INDEX SCRIPT_TEXTINDEX ON PropertyScript(script) INDEXTYPE IS ctxsys.context
ERROR at line 1:
ORA-03113: end-of-file on communication channel
which basically means that it just throw me out. But after I logged in again I noticed that the Index was created with the status 'Loading' and it just hangs there loading... and I can't drop it or do anything else.
Any insights? Thanks in advance!!!