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-6819426a42364534627808/]
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-6819426a42364534627808/]
Read More »In this article, I will make examples by explaining primary key and foreign key on delete and on update. [crayon-6819426a441fe277969502/] 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-6819426a4449a243278613/]
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-6819426a44cab565425616/]
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-6819426a44e36968830017/]
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-6819426a45d59279906753/] We can also …
Read More »We can see Running Job in Oracle Database using below code block. [crayon-6819426a45fa1800483107/]
Read More »