Oracle to MySQL Heterogeneous Unidirectional Replication

Oracle to MySQL Heterogeneous Unidirectional Replication In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and  MySQL. Source : Oracle DB Target :  MySQL Download Goldengate Binaries  Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you are using… Read More

Implementing Interval Partition with Enable Row Movement

Implementing Interval Partition with Enable Row Movement In this article , we will learn how to implement interval partition with enable row movement. Table Creation with interval partition (without interval Row Movement. Create user 

Now create table with interval partition.

Now try to… Read More

Online Segment Shrink

Online Segment Shrink A segment is a logical storage structure that contains data structure (segment type) of database objects. A segment is a set (unordered) of extents. A segment and all its extents are stored in one tablespace. From Oracle Database 10g, we can use the segment shrinking capability to reclaim unused… Read More

Oracle Security Audit: SQL92_SECURITY

SQL92_SECURITY   Oracle Security Audit: Q:  How to improve security level for DML transactions?. Ans: By setting the SQL92_SECURITY parameter we can improve the security level for DML transactions. The configuration option SQL92_SECURITY specifies whether table-level SELECT privileges are required to execute an update or… Read More

PERFORMING RMAN CLONING ON DIFFERENT SERVERS

PERFORMING RMAN CLONING ON DIFFERENT SERVERS In this article we will implement RMAN Cloning on different servers.

Server 1 : Check instance information on server 1 

Check schema report by connecting RMAN 

Check archive-log  

Shutdown the database and keep database… Read More