January 2017 – SHA Infotech

January 19, 2017January 19, 2017Uncategorized

Partitioned Table Purging Live Steps

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 […]

January 18, 2017Uncategorized

Table Partition Purging

sql> create table source_partitioned ( a number, b varchar2(1), c date) partition by range (c) ( partition p1 values less than (date […]

January 17, 2017February 14, 2017Uncategorized

Oracle Golden Gate

GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the […]

January 14, 2017Uncategorized

Oracle 12c New Features

Top 12 Features of Oracle 12C Summarized. Summary: The Oracle 12C means different things to different people. It all depends on which […]

January 14, 2017Uncategorized

Golden Gate

Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high […]