Export Dump file not compatible with Target Version

Please click on the INDEX and browse for more interesting posts. Recently while I was trying to import a Dump file from Production to Non Prod, I received the below error:  ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 12.1.0.2.0  ...

Oracle DBA Interview Questions – Part 2

Please click on the INDEX and browse for more interesting posts. 1. If you are having an expdp dumpfile and the client missed to give you what all schemas or tablespace are there in the dump. How will you find out? We can generate the DDL for the dumpfile using the...

Steps to delete a node in Oracle RAC 19c

In this post, we will delete a node to our existing Oracle Clusterware. This is required for multiple reasons as per needs Please click on the INDEX and browse for more interesting posts. Existing node : Jack, Jill Node to be Deleted : Jill NOTE : Due to resource...

Steps to add a node in Oracle RAC 19c

In this post, we will add a node to our existing Oracle Clusterware. Please click on the INDEX and browse for more interesting posts. Existing node : Jack New Node : Jill NOTE : Due to resource crunch, we could add a node to a single node RAC system. The steps are...

Oracle DBA Interview Questions – Part 1

Please click on the INDEX and browse for more interesting posts. Below are some 50 Oracle DBA interview questions that you may encounter. We will constantly updating our blog with more questions. Please check the INDEX link provided above for more posts regarding...