Take Control: True Private Internet Browsing with Brave Download the Brave Browser ⇒ A safer and faster alternative than Chrome. It’s also free and you support my website 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 […]
Catégorie : Datapump
Generate user DDL with dbms_metadata.get_ddl user
Take Control: True Private Internet Browsing with Brave Download the Brave Browser ⇒ It’s a safer and faster alternative than Chrome 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 […]
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/’; — […]