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

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-6875e75562242858466054/]  

In this article, I will make examples by explaining primary key and foreign key on delete and on update. [crayon-6875e755631e2974895095/] While creating the personnel table …

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-6875e75563392461140441/]

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-6875e7556441f191064002/]

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-6875e7556458d539924866/]

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-6875e75564bf4494652394/] We can also …

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