In today’s article, I will explain the difference between PostgreSQL GENERATED ALWAYS and SERIAL. The serial data type is one of the previously used data …
Read More »ORACLE
Data Pump Export Parallel
The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports. [crayon-66280fbed54a0977834597/] We can also …
Read More »How Can I See Running Job In Oracle Database
We can see Running Job in Oracle Database using below code block. [crayon-66280fbed573d403610598/]
Read More »Dump File Reuse
We can use the existing dump file with the same name only once. If we want to use it continuously, reuse_dumpfiles=y is used. [crayon-66280fbed58e7526745355/]
Read More »Empty Trash In Oracle
In today’s article, I will answer the question of How to Empty the Trash in Oracle Database. To remove the entire contents of your recycle …
Read More »Oracle Make Copy Of Schema
Today I will be explaining How to Make Copy of Schema in Oracle Data Pump. 1. We take an export backup of the schema to …
Read More »ORA-01665: Control File Is Not A Standby Control File
In today’s article, I will share with you the solution to the error I got after restoring the backup database from the RMAN backup. Error: …
Read More »Stop The Job
It may be necessary to temporarily stop a running export/import process for some reason. In this case, we may need to attach it first. 1. …
Read More »Active Session In Oracle
In today’s article we will learn How to See Active Session in Oracle Database. With the help of the code block below, we can see …
Read More »Export/Import Job Attach
We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need …
Read More »