I have a problem that the following statement took over 2 days before we stopped it.
CREATE INDEX version_ldocument_idx ON version(document) INDEXTYPE IS ctxsys.context
document is a blob field, the size of the tablespace is say 20 gigs and the average file size is around 3-5 megs.
My question is how long should this take?
If its longer than 2 days, is there a way that I can break the operation into smaller pieces?