Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> CREATE INDEX PARALLEL clause => bad datatypes?
Hi...
i've got a table where i'm trying to
CREATE INDEX pk_id on content(id DESC) PARALLEL (DEGREE DEFAULT);
but i get an error for Oracle (932) saying something about inconsistent data types, and the explanation of the error doesn't match any of the criteria i have in my table. id is declared as a NUMBER (30) but it's in my table, which created successfully.
The error message said it was either a bad DML statement (mixing numbers with text) or an attempt to modify a system table but neither are true.
If i remove the PARALLEL clause, the create succeeds. I have another table with an index created similarly on a text column and it worked fine with the parallel clause...
can someone shed some light on this?
thanks
-mark
Received on Mon May 22 2000 - 00:00:00 CDT