This error is occurs because the statistics belonging to the External Table cannot be collected while collecting the statistics belonging to the tables. Solution: We …
Read More »ORACLE
Oracle GoldenGate Deinstall
In today’s article we will be discussing how to remove GoldenGate in Oracle. The GoldenGate application is automatically removed by following the steps below. 1. …
Read More »Install Oracle GoldenGate 12.2.0.0.0
In today’s article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0. Before starting the GoldenGate installation, GRID, RDBMS and Database are installed …
Read More »Oracle Enterprise Manager Commands
In today’s article, we will be talking about the three basic commands of Oracle Enterprise Manager: Start, Status and Stop. 1. Start OEM; [crayon-674244aabb092735934306/] 2. …
Read More »Database Based Authorizations In PostgreSQL
Today, we will discuss how you can define database-based authorizations for your user created on a database basis in PostgreSQL. Authorizations defined on a database …
Read More »How To Start And Stop Oracle Enterprise Manager
In today’s article, we will be covering How to Start, Stop and View the Status of Oracle Enterprise Manager. START 1. Connect to the DB …
Read More »Install Oracle Enterprise Manager With DBCA
In today’s article, we will explain step by step how to install Oracle Enterprise Manager with DBCA. 1. We open a new terminal window on …
Read More »How To Migrate From MySQL To Oracle
In this guide, we will explore the step-by-step process of migrating from MySQL to Oracle, covering key concepts, tools, and best practices to ensure a …
Read More »Roles In Oracle Database
In today’s article, we will explain concepts such as defining roles in Oracle and which users have which roles. When you want to grant the …
Read More »Materialized Views In Oracle
In today’s article, we will be explaining the concept of Materialized Views in Oracle, also known as Snapshots. It is a structure that stores the …
Read More »