OraFAQ Forum: Server Administration » How to change partitioning (range-list) to (range)?

Home » RDBMS Server » Server Administration » How to change partitioning (range-list) to (range)?

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

How to change partitioning (range-list) to (range)? [message #403762]

Mon, 18 May 2009 09:34

wakula
Messages: 150
Registered: February 2008
Location: Poland

Senior Member

Hello,

I have 2 tables that are partitioned by range, subpartitioned by list. Initially that was subpartitioned by subpartition template.
Is there any way to convert that table into partitioned table without subpartitions?

I can set the subpartitioning template to (), but it does not change the table (it is still composite range-list).

The reason is that some automated code tries to execute ALTER INDEX REBUILD PARTITION which fails because the partition is subpartitioned.

Report message to a moderator