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
- Real-time cascading within Oracle Data Guard 12c
- Deploy OEMCC 13c5 Agent In Silent Mode
- Get OEMCC 13c5 Agent zip file
- Oracle ACE
- CRS-6706: After Grid Infrastructure upgrade from 19.3 to 19.12
- Upgrade Oracle Home 19c Software (19.3 to 19.12)
- OPatch 12.2.0.1.27 for DB 19.0.0.0.0
- Convert RAC 19c administrator managed to policy manager
- Convert Oracle RAConeNode to RAC 19c, Database is administrator managed
- Convert Oracle RAC to RAConeNode 19c, Database is administrator managed
- Upgrade Oracle Database RAC 2 nodes CDB, 2 PDBs from 19.3 to 19.9
- Upgrade Oracle Clusterware GI 19c from 19.3 to 19.9
- Upgrade the oracle Opatch
- Check Oracle Clusterware patch release
- Max 3 PDBs within 21c Standard Edition S2, not bad
- Upgrade Oracle Home 19c (19.3 to 19.9)
- RMAN-08138: warning: archived log not deleted – must create more backups
- RMAN-08591: warning: invalid archived log deletion policy
- Password-Mode Decryption RMAN Backup
- Password-Mode Encryption RMAN Backup
- Black or White List by IP address SQL NET
- Register Oracle service name on Listener other than 1521
- Create a Service Naming with NETMGR within Oracle 12.2
- Create a Listener with NETMGR within Oracle 12.2
- Convert Oracle Dedicaded to shared server
- [DBT-12510] The database option ‘SAMPLE_SCHEMA’ is not feasible to be installed in the current Oracle home.
- Convert Oracle RAC 19c Policy manager to Administrator managed
- Install Oracle Database 19c Silent Mode On Oracle Linux 8
- [FATAL] [DBT-06103] The port (5,500) is already in use. ACTION: Specify a free port, Oracle 19c
- [WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ 19c on Oracle Linux 8
