| 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!
|
|
|
| Re: ora-29952 when split partition [message #417296 is a reply to message #417294] |
Fri, 07 August 2009 01:14  |
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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
|
|
|
] 
Members
Search
Help
Register
Login
Home
