Oracle Books

This post is to share the links for Oracle books for better understanding of Oracle Internals and other exam guides to prepare for Oracle exam. Oracle 12c Books:- OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) OCA Oracle Database 12c Installation…

Datapump Export (Everything you need to know)

This post is to describe all the clauses available with Oracle datapump export (expdp). This article assumes that the reader has basic knowledge of database administration. If not gone through yet please go through the articles Oracle datapump Architecture & Internals so that you have basic architecture understanding of datapump. Oracle 12c datapump have following clauses, which…

Queries to Monitor Datapump Jobs

This post is to cover the queries that could be used to monitor the running Datapump Jobs. Without wasting anytime just posting the methods/queries which can be used to monitor the details of the datapump jobs:- 1) Using the datapump client (expdp & impdp) STATUS command:- When the export or import job is running press +C…

How to read Datapump Dumpfile Headers

Ever got into a scenario where you have a dump file without the logfile and not even sure what was the Oracle database version from where this was exported, the characterset, Operating system and other details of the Source Database ? Or even when you are not aware of which utility was used to export…

Oracle datapump Internals

In this series we’ll share the internals of the Oracle datapump, how to improve performance of a datapump job, how to monitor datapump jobs, how to read the header information from the dump file. Please feel free to comment if you want any other details regarding datapump to be covered. Datapump Architecture & Internals. How…