February 5, 2017March 26, 2017Uncategorized RAC BASIC RAC 11g useful commands Check the status of the cluster [oracle@rac1 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online […]
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 […]