Home » RDBMS Server » Server Administration » How to change partitioning (range-list) to (range)?
How to change partitioning (range-list) to (range)? [message #403762] Mon, 18 May 2009 09:34 Go to next message
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.
Re: - please ignore thispost - [message #403765 is a reply to message #403762] Mon, 18 May 2009 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
dbms_redefinition
Re: How to change partitioning (range-list) to (range)? [message #403767 is a reply to message #403762] Mon, 18 May 2009 09:45 Go to previous message
wakula
Messages: 150
Registered: February 2008
Location: Poland
Senior Member
As reported by BlackSwan: dbms_redefinition
Thanks BlackSwan!
Previous Topic: The Network Adapter could not establish the connection
Next Topic: Memory allocation between OS and Oracle
Goto Forum:
  


Current Time: Fri Dec 09 23:32:31 CST 2016

Total time taken to generate the page: 0.08645 seconds