Daily Archives: August 13, 2025

Resolving ORA-39405: Upgrading Target Database Time Zone File to Match Source in Oracle Data Pump Imports

Introduction 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 More

 Issue faced after cloning pluggable database

Verify 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 More

How to change the Database SYS password in OCI console

Step 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 More

Merging JasperReports into a Single Document (PDF or More)

Introduction: – This document explains how to merge multiple JasperReports into a single PDF or another output format using Java. The following technologies have been used to merge multiple JasperReports into…

Read More

Designing AOP Templates: Single Header and Multi-Row Detail Records using SQL and Oracle APEX

Introduction: – This document explains how to create an SQL-based data source for an AOP template that includes a single-value header followed by multi-row detail records. The following technologies are…

Read More