Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

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-679035c2b4737309481373/]

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 …

In today’s article, I will be explaining How to Create a PostgreSQL Data Type using the concept of Domain. It is very similar to the …

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

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-679035c2b50c6903692093/]

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-679035c2b53e0909730582/] We can also …

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

In the table, we can use column restrictions on how to keep the data in general, whether to enter a null value in the relevant …

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-679035c2b5912233609032/]