Partitioned Table Purging Live Steps

Posted on 245 CommentsPosted 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 Partition Purging

Posted on 729 CommentsPosted 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’) , […]

Oracle Golden Gate

Posted on 115 CommentsPosted in Uncategorized

GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the exchange and manipulation of data at the transactional level between a variety of database platforms like Oracle, DB2, SQL Server, Ingres, MySQL etc. It can support a number of different business requirements like: […]

Oracle 12c New Features

Posted on 179 CommentsPosted in Uncategorized

Top 12 Features of Oracle 12C Summarized. Summary: The Oracle 12C means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas. Summarized below is the list of Top 12 Features of Oracle 12C as I see it. I have summarized below, the […]

Golden Gate

Posted on 38 CommentsPosted in Uncategorized

Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. Oracle GoldenGate 12c brings extreme performance with simplified configuration and management, tighter integration […]