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

Today, I will describe the installation of the Oracle Linux 8 operating system, of which we have published previous versions. Oracle Linux is an extremely …

In PostgreSQL, we can easily perform operations such as addition, subtraction, division, multiplication, square root or factorial between numbers or two columns. Operator Icons Let’s …

In today’s article, I will be explaining how to do Partition Table Export AND Import in 3 steps. 1. We export the PARTITIONED TABLE, which …

In today’s article, we will cover about how we can Activate the Redhat 8 Cockpit Web Console to speed up our work. It is an …

In today’s article, we will cover about the Postgresql Unlogged Table feature, which came into our lives with the PostgreSQL 9.1 version and significantly increased …

In today’s article, we will learn how to migrate the current data directory to a different location in PostgreSQL. We can follow the steps below. …

We can import an object from the database to a different database and a different tablespace with a different schema. 1. First, let’s get this …

In today’s article, we will cover about the standard installation of Redhat 8 Enterprise, which is the best server operating system in its class in …

In this article, I will talk about using the INHERIT feature while creating a table and the details about it. INHERIT allows us to inherit …

Instead of rewriting the commands each time, we can use a parameter file to export/Import with Data Pump. 1. First we create the parameter file. …