Home » SQL & PL/SQL » SQL & PL/SQL » Partitioned Index-Organized table (11g R2)
Partitioned Index-Organized table [message #571883] Mon, 03 December 2012 09:28 Go to next message
TRaj
Messages: 80
Registered: September 2006
Member

Hi

I have an IOT table with partitioned on list. I have p1,p2 and p3 partitions.

Now I would like to create a bitmap index on partition key.

I gave ALTER TABLE .. MOVE MAPPING TABLE;

But getting the below error,

ORA-28660: Partitioned Index-Organized table may not be MOVEd as a whole.

Is there any solution ....

Thanks.

Re: Partitioned Index-Organized table [message #571885 is a reply to message #571883] Mon, 03 December 2012 09:30 Go to previous message
BlackSwan
Messages: 22677
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

28660, 00000, "Partitioned Index-Organized table may not be MOVEd as a whole"
// *Cause: Attempt to MOVE partitioned IOT as a whole
// *Action: don't do this. This is not supported
Previous Topic: Partition
Next Topic: Initialize a variable with a whole array
Goto Forum:
  


Current Time: Wed Aug 20 04:18:18 CDT 2014

Total time taken to generate the page: 0.10413 seconds