Why DELETE Cannot Be NOLOGGING in Oracle – Best Practices for Large Data Deletion
Introduction In Oracle databases, NOLOGGING is often used to minimize redo log generation for certain operations. However, many users wonder…
Oracle Database 20c Preview Released
Oracle Database 20c Preview Released https://blogs.oracle.com/database/ga-of-oracle-database-20c-preview-release
How to resync DR database after a long Gap
Check the scn on Standby database select min(fhscn) from x$kcvfh; Take incremental database backup on production Take incremental backup on…
Oracle GoldenGate Installation [10g to 12c Migration]
In this Post i will show how we done a Oracle GoldenGate unidirectional replication setup done for the Data Migration…
Upload Files to Oracle Cloud Object Storage (Windows/Linux)
This post discuss about uploading files from Windows/Linux Machines to Oracle Object Storage on OCI cloud. Oracle Cloud Object storage…
Auto Start Oracle Database on Linux
After successful installation of oracle database on Linux follow below procedure to autostart the oracle database after server reboot Auto…
Database Character set change on Oracle 18c Express Edition [Incl Installation steps on Oracle Free Cloud Linux instance]
Free Oracle Database for Everyone, Whether you are a developer, a DBA, a data scientist, an educator, or just curious…
Send Mail from Oracle database
Environment Details Oracle Linux Server release 7.4 Oracle Database 12.1.0.2.0 Putty -> For accessing the Linux Server Database Credentials SYS…