sql> create table source_partitioned
( a number, b varchar2(1), c date)
partition by range (c)
( partition p1 values less than (date ‘2017-01-01’)
, partition pmax values less than (maxvalue)
);
sql> create table target_partitioned
( a number, b varchar2(1), c date)
partition by range (c)
( partition p1 values less than (date ‘2017-01-01’)
, partition pmax values less than (maxvalue)
);
sql> create table partition_holder ( a number, b varchar2(1) , c date );
sql> insert into source_partitioned values ( 1, 1, date ‘2017-01-01’);
sql> insert into source_partitioned values ( 2, 2, sysdate);
sql> alter table source_partitioned exchange partition p1 with table partition_holder;
sql> alter table target_partitioned exchange partition p1 with table partition_holder;
sql> select * from source_partitioned;
A B C
———- – ——————-
2 2 2017-11-28 10:43:37
sql> select * from target_partitioned;
A B C
———- – ——————-
1 1 1998-01-01 00:00:00
sql> alter table source_partitioned exchange partition pmax with table partition_holder;
sql> alter table target_partitioned exchange partition pmax with table partition_holder;
sql> select * from source_partitioned;
sql> select * from target_partitioned;
A B C
———- – ——————-
1 1 2016-01-01 00:00:00
2 2 2016-11-28 14:38:22
18 thoughts on “Table Partition Purging”
Really a nice article. Helped me during my Purging activity 🙂
You are mistaken. I can prove it. Write to me in PM, we will discuss.
esmeraldama
Steps are ok I have tested in Lab, issue with the Output .. pasted from different env ..
digoxin cost buy digoxin buy generic molnunat 200 mg
buy diamox 250 mg without prescription buy imdur 20mg generic order imuran without prescription
order coreg 25mg pills order elavil 10mg online cheap amitriptyline medication
order fosamax generic order generic motrin motrin 600mg pills
priligy 60mg cheap purchase avana buy motilium pills
indocin capsule buy cenforce sale buy cenforce online
buy nexium 20mg sale order nexium 20mg online brand lasix 40mg
generic cialis india viagra 150mg for sale viagra 100mg england
minocin 50mg uk buy hytrin 5mg online cheap hytrin pills
clomid sale order clomid 100mg generic order prednisolone 20mg generic
order accutane online acillin for sale order ampicillin 250mg online cheap
ondansetron usa order ondansetron 4mg generic cost trimethoprim
buy accutane 40mg generic order zithromax 250mg pill buy zithromax 500mg pill
order prednisolone 10mg pill generic lasix cost lasix
cheap provigil 200mg modafinil online brand lopressor 50mg