I will explain How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump in this post. Let’s review the TABLE_EXISTS_ACTION in IMPDP in Oracle Datapump.
Read More »Oracle
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this post.
Read More »Ways to Rebuild Master Database in SQL Server Easily
Summary: The Master database is a very important database because it holds the primary configuration of the SQL database. But in case if it is corrupted then the user has …
Read More »Goldengate Performance
You should set STREAM_POOL_SIZE 2gb Disk quality and network bandwith should be high. You should add heartbeat source and target to analyezed lag. You should add batchsql , groupstransops 180000 …
Read More »Goldengate Troubleshooting
Hi , General errors and solutions for goldengate operations 1-) After goldengate upgrade from 12c to 19c , mapping error for replicat. You should add keycols parameter …
Read More »RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED and How to Drop Database including Backups RMAN
Hi, Sometimes You can get “RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED. ” error.
Read More »How to Add and drop Disks to ASM Disk Group in Oracle with Alter Diskgroup Add Disk Command
I will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. Let’s review the Add and drop Disks …
Read More »_ALLOW_RESETLOGS_CORRUPTION Parameter Usage in Case of Corruption with ORA-03113: end-of-file on communication channel
Hi, I will explain _ALLOW_RESETLOGS_CORRUPTION Parameter Usage in Case of Corruption in this post.
Read More »PL/SQL Conversion/Decoding/NULL-Related Functions
Hi Folks, Conversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The NULL-related functions facilitate …
Read More »How to Apply PSU Patch in Oracle and Patch Apply Steps
Hi, I will explain How to Apply PSU Patch in Oracle and Patch Apply Steps in this post. I will show you How to Apply PSU Patch in Oracle and …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial