by Animesh Kumar | Jan 19, 2017 | 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...
by Animesh Kumar | Jan 18, 2017 | 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...
by Animesh Kumar | Jan 17, 2017 | 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,...
by Animesh Kumar | Jan 14, 2017 | 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...
by upen | Jan 14, 2017 | 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,...
Recent Comments