PURPOSE AND SCOPE: This document explains how to transfer table data from source server to destination server. Prerequisites Database Access Permissions: Ensure that you have the necessary permissions to access…
Read MoreIntroduction In Oracle databases, performance issues often stem from inefficient SQL queries. TKPROF is a powerful utility that formats the output of SQL trace files, making it easier to interpret…
Read MoreIntroduction: When it comes to database performance tuning, that’s where Query Store appears. Introduced in 2017 version and significantly enhanced in 2019, Query Store acts like a “flight recorder” for…
Read MoreArchiving and Deleting Data From SQL Server Database Server: SERVER1 Main Database: DB1 Archive Database: DB1_archive Target Table: dbo.PerformanceCounters Objective: To archive and delete data older than 90 days from…
Read MoreIntroduction While working with Oracle databases, you may encounter the error ORA-00955: name is already used by an existing object when trying to create objects like tables, indexes, or materialized…
Read MoreIntroduction When performing an Oracle Data Pump import, mismatched database Time Zone File (TSTZ) versions between the source and target databases can cause an ORA-39405 error. This issue occurs because Oracle…
Read MoreVerify the pbs’s in the database. Create the pluggable database using the below command. In the above screenshot, new pluggable database opened with errors and in restriction mode. While verifying…
Read MoreStep 1: Login to database where you want to change the sys password. In the example we choose Oracle Base Database Service. Step 2 : In the Database Page :…
Read MoreIntroduction/ Issue In modern DevOps environments, automation is not just a luxury—it’s a necessity. When you’re managing hundreds of Linux virtual machines across hybrid or cloud-native infrastructure, manual configuration becomes…
Read MoreIntroduction/ Issue: With the growing adoption of hybrid cloud strategies, organizations often run critical workloads on-premises while embracing cloud-native management. One of the most innovative tools enabling this transformation is…
Read More