ORA-29849 exception [message #641034] |
Mon, 10 August 2015 01:38 |
|
sherlocksher
Messages: 14 Registered: June 2013
|
Junior Member |
|
|
Hi,
While doing a split partition operation, an exception with error code ORA-29489 ( error occurred in the execution of ODCIINDEXSPLITPARTITION routine) was logged. The sequence of steps is given below. As seen from the below sequence, in Step 4, an ORA-29489 error was logged in our exception table. Unfortunately there is no real time monitoring and we noticed this error only after a couple of days. Googling for more info about this error states that the action item is to verify if the routine has been coded properly and there is no additional info. Has any one encountered this error ? Is there a way to find out why this happened and what needs to be done to prevent it from happening again. Any pointers would be really helpful.
Note: However when the same step i.e Step 4 was re-run, it ran successfully.
--Step 1 Create table
CREATE TABLE test
(project_id number, project_name varchar2(1000), event_text clob, accum_text clob)
PARTITION BY RANGE (project_id)
(PARTITION pmax VALUES LESS THAN (MAXVALUE));
--Step 2 create preferences for context search
begin
ctx_ddl.create_preference ('skipJoinLexer1', 'BASIC_LEXER');
ctx_ddl.set_attribute ('skipJoinLexer1', 'skipjoins', ';:.,()<>*"''#-');
ctx_ddl.create_preference ('TextDS', 'MULTI_COLUMN_DATASTORE');
ctx_ddl.set_attribute ('TextDS', 'COLUMNS', 'EVENT_TEXT, ACCUM_TEXT');
END;
--Step 3 create local domain indexe
create index TEST_IDX on test (event_text) indextype is ctxsys.context parameters ('lexer skipJoinLexer1 datastore TextDS') LOCAL;
--Step 4 - Failed Step
ALTER TABLE test split PARTITION pmax AT (2) INTO ( PARTITION p_1, PARTITION pmax)
Thanks,
Vijay
[Updated on: Mon, 10 August 2015 01:55] Report message to a moderator
|
|
|