Sha Infotech is a DBA Training Center in Kolkata

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

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’) , […]

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

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

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