OraFAQ Forum: SQL & PL/SQL » Partitioned Index-Organized table

Home » SQL & PL/SQL » SQL & PL/SQL » Partitioned Index-Organized table (11g R2)

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

Partitioned Index-Organized table [message #571883]

Mon, 03 December 2012 09:28

thiagesh
Messages: 73
Registered: September 2006
Location: singapore

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.

Report message to a moderator

Re: Partitioned Index-Organized table [message #571885 is a reply to message #571883]

Mon, 03 December 2012 09:30

BlackSwan
Messages: 20092
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

Report message to a moderator

Previous Topic:	Partition
Next Topic:	Initialize a variable with a whole array

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 20:03:26 CDT 2013

Total time taken to generate the page: 0.24938 seconds