How to Manage (Kill, Cancel, and Resume) Datapump Jobs

We’ve all been there. You fire off a massive expdp or impdp job, grab a coffee, and then realize you forgot a specific table, the load is killing the CPU production, or you simply clicked "Enter" before you were ready. Panic sets in. Do you kill the OS process? Should you shut down the database? … Continue reading How to Manage (Kill, Cancel, and Resume) Datapump Jobs

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

Is it possible to map one Tablespace to many Tablespaces with impdp?

I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?