Home » RDBMS Server » Performance Tuning » Re-Partitioning (19C)
Re-Partitioning [message #685947] Mon, 02 May 2022 04:25 Go to next message
deepakdot
Messages: 72
Registered: July 2015
Member
Hi

I have a table with RANGE Partition. It has 4 partition. For e.g.

PARTITION P01 VALUES LESS THAN (250)
PARTITION P02 VALUES LESS THAN (500)
PARTITION P03 VALUES LESS THAN (750)
PARTITION P04 VALUES LESS THAN (1000)


Now I need to make it 10 Partition Like Blow. What should be the process to re partition this tables. Should we merge all the partition and re-partition it ? What is the best way to do this. the table will have huge data.

PARTITION P01 VALUES LESS THAN (100)
PARTITION P02 VALUES LESS THAN (200)
PARTITION P03 VALUES LESS THAN (300)
PARTITION P04 VALUES LESS THAN (400)
PARTITION P01 VALUES LESS THAN (500)
PARTITION P02 VALUES LESS THAN (600)
PARTITION P03 VALUES LESS THAN (700)
PARTITION P04 VALUES LESS THAN (800)
PARTITION P01 VALUES LESS THAN (900)
PARTITION P02 VALUES LESS THAN (1000)

Thanks
Deepak Samal
Re: Re-Partitioning [message #685948 is a reply to message #685947] Mon, 02 May 2022 11:35 Go to previous messageGo to next message
John Watson
Messages: 8719
Registered: January 2010
Location: Global Village
Senior Member
For example,
orclz>
orclz> create table parts(c1 number) partition by range (c1)
  2  (partition p1 values less than (10), partition p2 values less than (20));

Table created.

orclz>
orclz> alter table parts modify partition by range (c1)
  2  (partition p1 values less than (5), partition p2 values less than (10),
  3  partition p3 values less than (15), partition p4 values less than (20));

Table altered.

orclz>
Re: Re-Partitioning [message #685951 is a reply to message #685948] Wed, 04 May 2022 02:06 Go to previous message
deepakdot
Messages: 72
Registered: July 2015
Member
Thanks. This works for me.
Previous Topic: Correlated subquery iteration
Next Topic: excessive parsing ?
Goto Forum:
  


Current Time: Sat Jul 02 21:46:19 CDT 2022