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?