Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to create index (indextype is ctxsys.context )with NOLOGGING

883677May 11 2014 — edited Jul 15 2014

Hi Gurus,

Help please
: How can I specify NOLOGGING option? In the index command? In the attribute? What is the exact syntax if NOLOGGING is allowed at ctxsys.context?

Oracle version: 11.2.0.3.8


use the NOLOGGIN option of the create index command which is very simple to use at column indexes.
Which unclear to me how should I use in CREATE INDEX .. INDEXTYPE IS CTXSYS.CONTEXT command.
Following the CREATE INDEX command syntax seems oubvious - but it provides sytax error.
Maybe this is why CREATE INDEX .. INDEXTYPE IS CTXSYS.CONTEXT needs something different for options.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2014
Added on May 11 2014
#database-key-features, #text
1 comment
2,289 views