Download Brave : Secure, Fast & Private Browser with Adblocker In this article you will learn how to: Kill a datapump job from dba_datapump_jobs using expdp or with an internal package Cleanup orphaned datapump jobs in Oracle Perhaps you were looking for stop/drop job in DBMS_SCHEDULER. How to kill a datapump job in DBA_DATAPUMP_JOBS? You […]
Category: Datapump
Generate user DDL with dbms_metadata.get_ddl user
Download Brave : Secure, Fast & Private Browser with Adblocker The oracle DBA can use these 2 scripts to generate DDL statements for a user with their roles, system and object privileges. For Oracle 18c / 12c / 11g / 10g: clear screen accept uname prompt ‘Enter User Name : ‘ accept outfile prompt ‘ […]
Trace a specific ORA- error
How to trace a specific ORA- error that is raised and can be reproduced? We want to find the complete Oracle stack to understand the origin of this error. For example, I want to understand why datapump expdp/impdp raises: ORA-01422: exact fetch returns more than requested number of rows This time, the alert file is […]
Standard datapump use
How the Oracle DBA can use datapump in consistency mode with “flashback_time” : – Create the export directory – Verify the grantees on the export directory – Execute the datapupmp export with expdp in consistency mode – Execute an example of datapump import — Create the datapump directory SQL> create directory export as ‘/oracle/export/SID/’; — […]