Home » SQL & PL/SQL » SQL & PL/SQL » Domin index
Domin index [message #19444] Mon, 18 March 2002 07:29 Go to next message
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 Go to previous message
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
Previous Topic: Decode
Next Topic: Changing datatype
Goto Forum:
  


Current Time: Fri Mar 29 02:48:12 CDT 2024