Home » Server Options » Text & interMedia » ora-29952 when split partition (oracle 11gR1, linux)
ora-29952 when split partition [message #417294] Fri, 07 August 2009 01:06 Go to next message
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!
Re: ora-29952 when split partition [message #417296 is a reply to message #417294] Fri, 07 August 2009 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58497
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ora-29952 when split partition [message #417297 is a reply to message #417296] Fri, 07 August 2009 01:15 Go to previous message
Michel Cadot
Messages: 58497
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: phonetically search
Next Topic: CTXCAT indexes while migrating to Oracle 11g
Goto Forum:
  


Current Time: Wed Jul 23 07:03:13 CDT 2014

Total time taken to generate the page: 0.14601 seconds