Table Partition Purging

Posted on Animesh KumarPosted in Uncategorized

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

1,443 thoughts on “Table Partition Purging”

  36. Nicely put. With thanks.
    [url=https://homeworkcourseworkhelps.com/]do my homework[/url] do my online math homework [url=https://helpmedomyxyzhomework.com/]do my math homework for me free[/url] why cant i do my homework

    Reply

  40. You actually said that fantastically.
    [url=https://phdthesisdissertation.com/]dissertation help service[/url] uk dissertation writing help co [url=https://writeadissertation.com/]best dissertation writing service uk[/url] dissertation writing services reviews

    Reply

  42. You made your point.
    [url=https://homeworkcourseworkhelps.com/]coursework writing service[/url] my child refuses to do homework [url=https://helpmedomyxyzhomework.com/]idk how to do my homework[/url] just do my homework

    Reply

  44. Kudos. I enjoy this!
    [url=https://researchproposalforphd.com/]proposal writers[/url] term paper help [url=https://writingresearchtermpaperservice.com/]research paper writing services in india[/url] buy a research paper for college

    Reply

  46. Excellent advice. Thank you!
    [url=https://helpwithdissertationwriting.com/]dissertation paper[/url] dissertation uk [url=https://dissertationwritingtops.com/]dissertation[/url] dissertation help

    Reply

  47. You said it very well.!
    [url=https://bestpaperwritingservice.com/]pay to write paper[/url] pay someone to write a paper [url=https://bestonlinepaperwritingservices.com/]paper writing service[/url] buy a paper for college

    Reply

  48. Regards. I like it!
    [url=https://argumentativethesis.com/]thesis statement[/url] college thesis [url=https://bestmasterthesiswritingservice.com/]good thesis statements[/url] example thesis

    Reply

  50. You said that perfectly!
    [url=https://essaytyperhelp.com/]essaypro[/url] helping others essay [url=https://helptowriteanessay.com/]help with my essay[/url] paper writing help

    Reply

  53. Thanks a lot, I appreciate it.
    [url=https://essayssolution.com/]online essay writer[/url] do my essay free [url=https://cheapessaywriteronlineservices.com/]write a essay[/url] what should i write my college essay about

    Reply

  54. Regards, A good amount of knowledge!
    [url=https://ouressays.com/]custom research paper writing services[/url] research paper services [url=https://researchpaperwriterservices.com/]term papers[/url] writing proposal

    Reply

  57. Many thanks, I enjoy it.
    [url=https://domyhomeworkformecheap.com/]pay to do my homework[/url] do my homework for me [url=https://domycollegehomeworkforme.com/]xyz homework[/url] reddit do my homework

    Reply

  90. Good write ups. Many thanks.
    [url=https://writinganessaycollegeservice.com/]online essay writing services[/url] writing a reflective essay [url=https://essayservicehelp.com/]writing an argumentative essay[/url] smart writing service

    Reply

  91. [url=http://metforminr.online/]Order metformin[/url] can also interact with certain foods and supplements, so be sure to ask your doctor or pharmacist for advice.

    Reply

  95. At the beginning, I was still puzzled. Since I read your article, I have been very impressed. It has provided a lot of innovative ideas for my thesis related to gate.io. Thank u. But I still have some doubts, can you help me? Thanks.

    Reply

  103. Incredible lots of superb material.
    [url=https://argumentativethesis.com/]thesis statement meaning[/url] example thesis [url=https://bestmasterthesiswritingservice.com/]thesis writing service[/url] college thesis

    Reply

  110. Cheers, Terrific stuff.
    [url=https://writinganessaycollegeservice.com/]best custom essay writing service[/url] essay writing service uk cheap [url=https://essayservicehelp.com/]essay writing service coupon[/url] paper writing service

    Reply

  117. Regards! Numerous tips!
    [url=https://writingpaperforme.com/]paper writer services[/url] how to write a reflective paper [url=https://custompaperwritersservices.com/]lined writing paper[/url] online essay writer

    Reply

  123. Obrigado por compartilhar. Estou preocupado por não ter ideias criativas. É o seu artigo que me deixa cheio de esperança. Obrigado. Mas, eu tenho uma pergunta, você pode me ajudar?

    Reply

  127. Amazing loads of useful info.
    [url=https://customthesiswritingservice.com/]strong thesis statement[/url] thesis creator [url=https://writingthesistops.com/]thesis sentence[/url] thesis help

    Reply

  155. Fantastic data. Thank you.
    [url=https://englishessayhelp.com/]write my essay[/url] college application essay help [url=https://essaywritinghelperonline.com/]free writing assistant[/url] assignment help

    Reply

  242. Nicely put. Regards.
    [url=https://topswritingservices.com/]college essay service[/url] writing essay service [url=https://essaywriting4you.com/]top ten essay writing services[/url] best essay writing service

    Reply

  375. Fantastic information, Kudos.
    [url=https://argumentativethesis.com/]working thesis[/url] thesis statment [url=https://bestmasterthesiswritingservice.com/]how to write thesis[/url] a thesis statement

    Reply

  507. Wonderful stuff, Appreciate it!
    [url=https://dissertationwritingtops.com/]dissertation abstract[/url] dissertation writing [url=https://helpwritingdissertation.com/]dissertation proposal[/url] writing help

    Reply

  557. Very well spoken truly! !
    [url=https://theessayswriters.com/]write a essay[/url] essay writer free trial [url=https://bestcheapessaywriters.com/]essay writers[/url] writing a persuasive essay

    Reply

  603. Really all kinds of terrific information!
    [url=https://topswritingservices.com/]i need help writing an essay[/url] top ten essay writing services [url=https://essaywriting4you.com/]online paper writing service[/url] writing essay service

    Reply