ORACLE

We use ENCRYPTION as Encryption parameter in Oracle Data Pump. We can use the ENCRYPTION parameter with the values ALL, DATA_ONLY, METADATA_ONLY and ENCRYPTED_COLUMNS_ONLY. [crayon-6742ace30cc42758316474/]

In today’s article we will be learning How to See Block Session in Oracle Database. We can see the Block Session with the help of …

Compression parameter in data pump is COMPRESSION. COMPRESSION parameter can be used with ALL, DATA_ONLY, METADATA_ONLY and NONE values. [crayon-6742ace30d353836667478/]

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-6742ace30d51e007379291/]

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-6742ace30d9e4753099507/] We can also …

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

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-6742ace30e5b7830738555/]

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 …