tablespaces

26ai_en

Oracle Smallfile vs Bigfile Differences and Best Practices: A DBA’s Operational Guide

In the physical design of an Oracle Database, the choice of tablespace management method directly impacts future scalabi...
26ai_en

Oracle 26ai Tablespaces Default to Bigfile? Verification and Precautions

In Oracle Database 26ai (version 23.26.1 and later), the latest release for 2026, Oracle 26ai tablespaces are configured...
Data Dictionary Internals_en

Oracle Move Data Files: Safe Procedures and Examples [Linux/19c]

When reorganizing storage or cleaning up directories in your Oracle environment, knowing how to move data files safely i...
English

Oracle Database 19c User Creation and Management

In this article, we will walk through how to create and manage a user in an oracle database, specifically assuming a non...
Bronze_en

A Complete Guide to Creating Tables in Oracle Database [CREATE TABLE Explained]

Creating tables is one of the most fundamental skills when working with Oracle Database.This article provides a thorough...
Bronze_en

Complete Guide to Oracle CREATE USER: Explained with Diagrams

In Oracle Database, user management plays a crucial role in security, access control, and resource limitation.This artic...