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-683039bd3ba35121414186/]
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-683039bd3ba35121414186/]
Read More »In this article, I will make examples by explaining primary key and foreign key on delete and on update. [crayon-683039bd3d114638776261/] 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-683039bd3d315054554679/]
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-683039bd3e386868284921/]
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-683039bd3e54b029619738/]
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-683039bd3e858055565503/] We can also …
Read More »We can see Running Job in Oracle Database using below code block. [crayon-683039bd402f2579885102/]
Read More »