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
-
Oracle Certified Expert
-
Oracle Cloud Infrastructure
-
MySQL: Administrator Certified Professional
-
PostgreSQL: Certified Associate
-
-
Recent Posts
- Oracle Database Server/Client certificate/TCPS (Oracle 19c)
- Create Client Wallet and Certificate (Oracle 19c)
- Create Server Wallet and Certificate (Oracle 19c)
- Reinstate failed for Data Guard: Flashback Database is disabled
- Reinstate for Data Guard succeeded
- Physical/Logical Health Monitor check (Oracle 19c)
- Backup as copy database to an other server with RMAN (Oracle 19c)
- Restore/Recover datafile from Standby without database catalog (19c)
- Oracle Database Software Upgrade 19.18 to 19.19 (19c)
- RMAN duplicate Database for Data Guard ( 19c )
- Check/Recover a corrupted Block (Oracle 19c)
- RMAN duplicate to create a clone database READ/Write
- Oracle 23c: Change Database Name FREE to DB23c
- New Features 23c: GROUP BY with Aliases/Position Number
- New Features 23c: Table with EXIST or NOT EXIST Clause
- New Features 23c: Asynchronous Transactions
- New Features 23c: BOOLEAN Column Data Type
- New Features 23c: Table VALUES Constructor
- New Features 23c: Select without DUAL
- Cloud Control Enterprise Manager 13c, Email notifications
- Patch 34765931 – Database Release Update 19.18.0.0.230117 (REL-JAN230131)
- Create our first 23c instance: FREE
- Install 23c Oracle Database: Free Version
- Welcome 23c Oracle Database: Free Version
- Warning: ORA-16714: Some Parameter are inconsistent with the database setting
- Real-time cascading within Oracle Data Guard 12c
- Add Oracle database service Naming (tnsnames.ora) 19c
- Register Database services in Listener (Oracle 19c)
- Deploy OEMCC 13c5 Agent In Silent Mode
- Get OEMCC 13c5 Agent zip file
