ORACLE

In today’s article we will learn How to See Invalid Object in Oracle Database. We can See Invalid Object using the following code block. [crayon-67d4245ddf4db224991025/]

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 …

The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports. [crayon-67d4245de2260172058948/] We can also …

We can see Running Job in Oracle Database using below code block. [crayon-67d4245de23fa265632501/]

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-67d4245de25d2146564654/]

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 …

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 …

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

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. …

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 …