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

Posted on by Ahmed Abdel Fattah

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

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

Posted on by Ahmed Abdel Fattah

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?