Domin index [message #19444] |
Mon, 18 March 2002 07:29 |
Sue Sabol
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Do you know what is error on that code?
the following error has occurred:
OAR-29850: invalid option for creation of domain indexes
Thanks!
Sue
CREATE INDEX CONTENT_INDEX ON
MEDLINE(XMLCONTENT) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('FILTER CTXSYS.NULL_FILTER SECTION GROUP CONTENT_SECTION
STORAGE CTXSTORE
MEMORY 1M')
LOCAL
(
PARTITION P1 TABLESPACE SABOLSZ_A
PCTFREE 10
STORAGE (
INITIAL 20
NEXT 10
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
),
PARTITION P2 TABLESPACE SABOLSZ_B
PCTFREE 10
STORAGE (
INITIAL 20
NEXT 10
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
),
PARTITION P3 TABLESPACE SABOLSZ_C
PCTFREE 10
STORAGE (
INITIAL 20
NEXT 10
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
))
|
|
|
Re: Domin index [message #19497 is a reply to message #19444] |
Thu, 21 March 2002 19:12 |
nash
Messages: 10 Registered: February 2002
|
Junior Member |
|
|
ORA-29850 invalid option for creation of domain indexes
Cause: The user specified an invalid option like ASC, DESC, SORT or a Parallel Clause, Partitioning Clause or Physical Attributes
-------------------
HTH
nash
|
|
|