Database SQL; Delete vs Truncate and segment size allocated
This article shows the differences between SQL commands delete and truncate in Oracle Database with … Read More
Oracle ACE Pro
-
Oracle Certified Expert
-
Oracle Cloud Infrastructure
-
MySQL: Administrator Certified Professional
-
PostgreSQL: Certified Associate
-
-
Recent Posts
- Oracle 19c: Index-Organized Table (IOT)
- Oracle 19c – SQL Access Path: Index Skip Scan
- Oracle 19c – SQL Access Path: Index Full Scan
- Oracle 19c – SQL Access Path: Index Range Scan
- Oracle 19c – SQL Access Path: Index Unique Scan
- Oracle 19c – SQL Access Path: ROWID Scan
- Oracle 19c – SQL Access Path: Full Table Scan
- OS_AUTHENT_PREFIX External Authentication in Oracle Database 19c
- Oracle 19c Flashback Technology (7/7): Data Archives
- Oracle 19c Flashback Technology (6/7): Flashback Database/PDB
- Oracle 19c Flashback Technology (5/7): TRANSACTION
- Oracle 19c Flashback Technology (4/7): Table
- Oracle 19c Flashback Technology (3/7): Drop Table
- Oracle 19c Flashback Technology (2/7): Versions Query
- Oracle 19c Flashback Technology (1/7): Query
- Recommended UNDO Tablespace Size in Oracle 19c Using the Undo Advisor (SQL Only)
- Understanding UNDO Configuration and RETENTION GUARANTEE in Oracle 19c
- Materialized View Log in Oracle 19c (ON COMMIT)
- Materialized View Log in Oracle 19c (ON DEMAND)
- Reinitializing the Same Password After Expiration in Oracle 19c
- Switching Session User in Oracle Database
- Monitoring the Oracle Fast Recovery Area (FRA)
- Database 19c Vault: OWNER/Manager privileges !
- Enabling the Database Vault (Initialisation parameters)
- [FATAL] [DBT-09352] Error in validating dbv_owner credentials.
- Oracle 19c: Convert Table to range partition online
- Oracle 19c: Automatic List-Partitioned Table (2/2)
- Oracle 19c: Automatic List-Partitioned Table (1/2)
- Oracle 19c: Interval Partitioning (2/2)
- Oracle 19c: Interval Partitioning (1/2)
