Datapump_en Practical Steps to Extract Transportable Tablespaces with RMAN and Import via SQL Script
— Smart Migration using Automatically Generated Scripts instead of Data Pump —Oracle's Transportable Tablespace (TTS) is...
Tablespaces/Datafiles_en
Datapump_en Datapump_en Comprehensive Guide to Transportable Tablespaces (TTS) via Data Pump and RMAN
When migrating massive amounts of data—ranging from several GBs to multiple TBs—between Oracle databases, standard expdp...
English Recovery Procedures for Oracle Tablespace Failures: Recovery Flow Using RMAN
In Oracle Database operations, if a failure occurs in a specific tablespace, it is possible to recover only that tablesp...
English Complete Recovery Procedures for Oracle Database: Recovery Flow Using RMAN
When a failure occurs in an Oracle Database, a "Complete Recovery"—restoring the database to the state immediately prece...
English Recovery Procedures for Corrupted Blocks Using Oracle Data Recovery Advisor
In Oracle Database operations, data corruption is a situation you want to avoid; however, should the need arise, the Ora...
English How to Handle Increased SYSAUX Tablespace Usage
1. What is the SYSAUX Tablespace?The SYSAUX tablespace is an auxiliary tablespace for the Oracle database, primarily use...
English How to Make Oracle Tables Read-Only and Move Them [ALTER TABLE]
In the operation of Oracle Database, there are frequent situations where you want to prevent accidental updates to maste...
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...
English Explaining the ORA-1555 Error: Causes, Solutions, and Prevention
If you operate an Oracle database, you may have experienced the headache of the "ORA-1555: snapshot too old" error. This...
English Guide to UNDO Tablespaces and UNDO Segments
To properly operate an Oracle database, understanding the UNDO tablespace and UNDO segments is essential. This article i...
English A Complete Explanation of Segment Shrink vs. DELETE/TRUNCATE Behavior
Efficient operation of Oracle Database requires freeing unnecessary space and optimizing performance. At the core of thi...
English Oracle Database Segment Extension — Error Handling and Best Practices
In Oracle Database, as data grows, segments can run short of space, which may trigger errors and degrade performance. Th...
English What Are Deferred Segments? Usage and Caveats
In Oracle Database, when you create a table, a segment (the physical storage area for data) is usually allocated immedia...
English Explaining Segment Management in Oracle Database
To improve the operational efficiency of a database, you need to optimize storage management. At the center of that is s...
English Oracle Data Block Row Storage: Mechanism and Verification Steps
Introduction (Summary)In oracle, row storage inside a data block consists of “block header / directory / row data / free...
English How to Use Oracle Managed Files (OMF): Complete Guide to Configuration, Procedures, and Operations
Introduction (Summary)Oracle Managed Files (OMF) is a mechanism that auto-names and auto-places data files, temp files, ...
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...
Data Dictionary Internals_en Oracle Tablespace View Complete Guide: Verify Usage Correctly with DBA_* / V$*
This article explains how to correctly verify the usage and size of tablespaces in Oracle and how to expand capacity whe...
English Oracle Tablespace Local Management: How to Create and Choose
Introduction (100–160 chars)In oracle 19c, creating a tablespace with local management automates extent management and s...