In today’s article, we will be learning Who Uses Temp Tablespace in Oracle Database. We can find out using the following code block. [crayon-6887d969d5acc534703447/]
Read More »
In today’s article, we will be learning Who Uses Temp Tablespace in Oracle Database. We can find out using the following code block. [crayon-6887d969d5acc534703447/]
Read More »In this article, I will make examples by explaining primary key and foreign key on delete and on update. [crayon-6887d969d79b0891506865/] While creating the personnel table …
Read More »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-6887d969d7b38130769966/]
Read More »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 …
Read More »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 …
Read More »Compression parameter in data pump is COMPRESSION. COMPRESSION parameter can be used with ALL, DATA_ONLY, METADATA_ONLY and NONE values. [crayon-6887d969d8a3d771343675/]
Read More »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-6887d969d8f49033762663/]
Read More »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 »The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports. [crayon-6887d969d9b21812594385/] We can also …
Read More »We can see Running Job in Oracle Database using below code block. [crayon-6887d969d9f0d410833247/]
Read More »