OraFAQ Forum: Text & interMedia » ora-29952 when split partition

Home » Server Options » Text & interMedia » ora-29952 when split partition (oracle 11gR1, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-29952 when split partition [message #417294]

Fri, 07 August 2009 01:06

Lincon
Messages: 2
Registered: July 2009

Junior Member

Hi, everybody.
In my test of partition split and context index, the error occured in splitting partition sometimes.
Any advice is helpful!

Report message to a moderator

Re: ora-29952 when split partition [message #417296 is a reply to message #417294]

Fri, 07 August 2009 01:14

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Without the actual statement and actual error you got it is hard to help.
Use SQL*Plus and copy and paste your session.
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel

Report message to a moderator

Re: ora-29952 when split partition [message #417297 is a reply to message #417296]

Fri, 07 August 2009 01:15

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, didn't see the error is in the title:

ORA-29952: cannot issue DDL on a domain index partition marked as LOADING
 *Cause: Tried to issue a DROP/ALTER/TRUNCATE on a domain index partition
         in a LOADING state.
 *Action: Wait till the index partition operation completes
          OR issue a DROP INDEX FORCE to drop the index
          OR issue a ALTER TABLE DROP PARTITION to drop the partition.

Statement you executed is still necessary.

Regards
Michel

Report message to a moderator

Previous Topic:	phonetically search
Next Topic:	CTXCAT indexes while migrating to Oracle 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 19:12:39 CST 2025