ora-29952 when split partition [message #417294] |
Fri, 07 August 2009 01:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #417297 is a reply to message #417296] |
Fri, 07 August 2009 01:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|