How to export an oracle database schema using Oracle Data Pump?

In this quick demo, I'll explain to you the steps to export one schema called OE using expdp utility. Please note that you should already created a directory to hold the dump files and log files, using the following steps: https://www.youtube.com/watch?v=FOAlULoHrqA ThanksAhmed

Oracle Enterprise Manager Database Control & Time Zone

Background: Egypt time zone is GMT+2. Starting from year 1988, Egypt started to use the summer time zone (GMT +3) starting from the last Thursday of Apr till the last Thursday of September (5 months), then it reset back to GMT +2 for the remaining of the year. Summer time zone was cancelled at 20-Apr-2011, … Continue reading Oracle Enterprise Manager Database Control & Time Zone

Oracle Data Pump Import Log File Analysis

In most (or all) cases , when you fully import the database using oracle data pump or the old “imp” import utility , you will get some errors. Some of them are expected and could be ignored and some need close attention to investigate and fix. For big databases, the import log file may be … Continue reading Oracle Data Pump Import Log File Analysis