Partitioned Table Purging Live Steps

Posted on Posted in Uncategorized

create table archive.archive_tasks partition by range (TIME) (partition ARC_Pdefault values less than (to_date(’01-10-2008′, ‘DD-MM-YYYY’)) ) as select * from tasks where 1=2 ;

create table archive.partition_holder_tasks as select * from TASKS where 1=2;

alter table TASKS exchange partition Pdefault with table archive.partition_holder_tasks;

alter table archive.archive_tasks exchange partition arc_pdefault with table archive.partition_holder_tasks;

— Adding Partition
alter table archive.archive_tasks add partition P1460 values less than (to_date(‘2016-09-13 00:00:00′,’yyyy-mm-dd hh24:mi:ss’));

alter table TASKS exchange partition sys_p1460 with table archive.partition_holder_tasks;

alter table archive.archive_tasks exchange partition p1460 with table archive.partition_holder_tasks;

Drop existing Partition

Rebuild Index created on Base table.

24 thoughts on “Partitioned Table Purging Live Steps

  1. Quicker and Simpler than the SBA, http://BusinessCapitalAdvisor.com can get your business a loan for $2K-350,000 With low-credit and without traditional personal guarantees or collateral.

    Use our 1 minute form to Find Out exactly how much you can get, No-Cost:

    http://BusinessCapitalAdvisor.com/?url=sha-infotech.com&id=e319

    If you’ve been established for at least a year you are already pre-qualified. Our Quick service means funding can be completed within 48hrs. Terms are personalized for each business so I suggest applying to find out exactly how much you can get.

    This no-cost service does not require any personal information since the amount is based on annual revenue of your business. Funds are also Non-Restrictive, allowing you to use the full amount in any way including bills, taxes, hiring, marketing, expansion, or Absolutely Any Other expense.

    There are limited SBA and private funds available so please apply now if interested,

    Click Here: http://BusinessCapitalAdvisor.com/?id=e319

    Have a great weekend,
    The Business Capital Advisor Team

    unsubscribe here – http://remove.businesscapitaladvisor.com/?url=sha-infotech.com&id=e319

Leave a Reply

Your email address will not be published. Required fields are marked *

4 × 7 =