Oracle Text (MOSC)

MOSC Banner

creating local partition ConText index

edited Aug 30, 2010 1:25AM in Oracle Text (MOSC) 2 commentsAnswered
 Having issues in creating a local partitioned index for text search:

Successfully created range partitioned (4 partitions) table on a date value. Attempting to create a local partitioned text index (ConText) on this table. The preferences have bee successfully created. When executing "create index" ddl, receive the errors: ora-29959 error in the execution of the ODCIINDEXCREATE routine for one or more of the index partitions, ora-29960: line 1, drg-11110 populate index error on index partition "CY2010_02", drg-50857 oracle error in drvxtab.create_index_tables ora-00955: name already in use. This error is listed for 3 of the 4 partitioned indexes; the first index partition is successfully created/populated. The sample create index statement is below

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center