In today's article, we will learn how to Add Data File to Tablespace with queries step by step. 1. Columns and data types are learned from dba_data_files. You can learn whether dba_data_files is a view or a table as follows. In TOAD, we write dba_data_files on the editor screen and hold down Ctrl while moving

Database Tutorials

13.01.2025

PostgreSQL Role Authentication Methods - Database Tutorials

In today's article, we will explain the PostgreSQL role authentication methods, including trust, md5, sha256, and ident on pg_hba.conf. Authentication in PostgreSQL involves the use of both pg_hba.conf and postgresql.conf. To connect a user to PostgreSQL, the system first checks the pg_hba.conf file. Based on the method defined there, authentication is performed. If authentication is

Database Tutorials

15.01.2025

Linux Top Command - Database Tutorials

In this tutorial, we will learn to use the top(table of processes) command in Linux and see some practical examples. The top command shows a dynamic, real-time view of running processes and kernel-managed tasks in Linux. The command also provides a system information summary that shows resource utilization, including CPU and memory usage. Syntax top

Database Tutorials

18.01.2025

How to Change Database OWNER in PostgreSQL - Database Tutorials

In today's article, we will explain how to change the OWNER when creating a database and after it has been created in PostgreSQL. PostgreSQL provides an ALTER DATABASE command that allows us to modify a database. For instance, using ALTER DATABASE command, you can alter the database name, attributes, owner, etc. In Postgres, the ALTER

home›Database Tutorials

Database Tutorials

Software

Add Data File to Tablespace - Database Tutorials

PostgreSQL Role Authentication Methods - Database Tutorials

Linux Top Command - Database Tutorials

How to Change Database OWNER in PostgreSQL - Database Tutorials

home
›
Database Tutorials