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. …
Read More »Importing Objects From A Different Tablespace
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 …
Read More »Download Redhat Enterprise Linux 8
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 …
Read More »Create Table Inherits PostgreSQL
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 …
Read More »Using Parameter Files
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. …
Read More »ORA-01184: Logfile Already Exists
In today’s article, we will look at the cause of a possible error that we may receive if we want to add Redo Log on …
Read More »PostgreSQL Temporary Table
In today’s article, What is a PostgreSQL Temporary Table? and How to Create? We will inform you about the subject. Most of the things I …
Read More »Oracle Remap Table
In today’s article, we will learn how we can create a Oracle Remap Table in three steps. 1. The table is exported from the first …
Read More »ORA-39070: Unable To Open The Log File
Today, I will be sharing with you the reasons for the ORA-39070 error we received on Oracle Database and how to solve it. Error; ORA-39070: …
Read More »PostgreSQL Generated Column
PostgreSQL Generated Column (Computed Column) is an operation on two or more columns and printing them into a different column. Computed Column is available with …
Read More »